Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “douse” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

194 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
douse6632972(None) 
bouse75931851bouse
dose56442431do_se
douce85518421douce
doused84821161doused
douser75621631douser
douses74928931douses
dowse96020811dowse
druse64817661druse
house89131421house
louse56131011louse
mouse77133001mouse
rouse56634701rouse
souse56530771souse
touse55430671touse
youse85322231youse
abuse77119562abuse
amuse75920832amuse
arouse65019982arouse
blouse84714722blouse
boule74828042boule
bourse84414332bourse
boused95322882boused
bouses84931782bouses
bousy104917842bousy
bowse105420632bowse
cause75225352cause
chouse116017562chouse
copse95623922copse
corse75036182corse
coude85022632coude
coupe96023482coupe
course85117772course
crouse84619362crouse
cruse75726102cruse
daube85015302daube
defuse105712722defuse
delouse839832delouse
dense65923502dense
deuce84517492deuce
disuse74012832disuse
dobie84920322dobie
docs75631152docs_
dodge86618122dodge
doe47361952do__e
does56554472does_
doest65829522doest
doge66233802do_ge
doges75630162doges
dogie75222792dogie
dogs66440152dogs_
dolce85816682dolce
dole56550002do_le
doles67843752doles
dols56943052dols_
dome77240732do_me
domes85735562domes
doms76239572doms_
done55747912do_ne
donee66931012donee
donne65520462donne
dons56048702dons_
donsie7613642donsie
donsy96414682donsy
dope76038892do_pe
dopes84935042dopes
dore56353302do_re
dors56747602dors_
dorsa64617282dorsa
dorsel75315502dorsel
dorser74819172dorser
dos48062312do_s_
dosed76626912do_sed
doser66228562do_ser
doses65938502do_ses
doss56235042do_ss
dossed84516632dossed
dossel74813642dossel
dosser74417972dosser
dosses76126272dosses
dost57248352do_st
dote55442882do_te
dotes65836692dotes
dots55647662dots_
double94013992double
doubt8720092doubt
douche124613222douche
dough105217382dough
doula65717772doula
doum76226672dou_m
douma85817702douma
doums85417642doums
dour56330432dou_r
doura66518662doura
dourer74215272dourer
dousers84817272dousers
doux125817982dou_x
dove85131562do_ve
doves94728152doves
dowie94721142dowie
dows85941052dows_
dowsed115015012dowsed
dowser104716082dowser
dowses105718302dowses
doxie136017152doxie
doze145829082do_ze
dozes155226302dozes
drowse105010552drowse
drupe85012992drupe
druses75517252druses
duce76933502d_uce
dude65629662d_ude
due45249862d_u_e
dues56045502d_ues
duke95628102d_uke
dulse65415042dulse
dune56137582d_une
duos56728132duos_
dupe76630602d_upe
dure56341812d_ure
dusk95724152d_usk
dust57142532d_ust
fosse86119462fosse
fuse76429992_fuse
goose65925902goose
gorse65926812gorse
gouge78220062gouge
grouse74315022grouse
hoise85224772hoise
horse86132652horse
hose76547242ho_se
housed105624102housed
housel95217042housel
houser95322282houser
houses96032272houses
joule124918202joule
joust125122292joust
loose56627682loose
lose45144582lo_se
louie55023512louie
loupe75319512loupe
loused74822912loused
louses66230282louses
lousy84617082lousy
lowse87219902lowse
moose76327192moose
morse76032702morse
moue65835572mou_e
moues75732842moues
moused94423302moused
mouser85822442mouser
mouses85531422mouses
mousey115216192mousey
mousse84813032mousse
mousy106716942mousy
muse67136032_muse
noise55723732noise
nonuse63212252nonuse
noose55624062noose
nose46739362no_se
nous46136982nous_
nouses64627162nouses
ose38147342_o_se
ousel55222402_ousel
oust46747442_oust
owse76321622_owse
pause75021832pause
poise75127892poise
pose66441732po_se
posse74722272posse
reuse56025362reuse
roose56127092roose
rose46148902ro_se
roue45941742rou_e
roues56039352roues
rouge65423442rouge
roused75426442roused
rouser65224082rouser
rouses65436282rouses
roust55532062roust
route55132072route
ruse45938932_ruse
scouse84113632scouse
sous46947212sous_
soused74822982soused
souses64229242souses
spouse84112512spouse
torse55833332torse
toused74122012toused
touses64229672touses
tousle64514652tousle
use36835162__use
worse86525262worse
yous76230652yous_

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.0931921408.6
2DLD Change Limit538001941.82629463.3
3Display Results1941940.0633079.4
 (SQL Overall)1786911941.98290156.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.