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 “lotuses” with Change Limit: [1] [2] [3]

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

490 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
lotuses7401125(None) 
lotoses73713641lotoses
louses66230281lo_uses
blouses94014462blo_uses
boluses94113832boluses
bonuses94212952bonuses
bouses84931782bo_uses
clonuses1057132clonuses
clotures10299022clotures
coituses1039622coituses
contuses10413452contuses
douses74928932do_uses
fetuses10310242fetuses
flatuses1137172flatuses
focuses12159652focuses
foetuses1136082foetuses
hocuses121710422hocuses
houses96032272ho_uses
ictuses938292ictuses
litmuses1044462litmuses
lobules92510812lobules
locules92812602locules
locusts9277932locusts
loesses7310032loesses
looses67328242lo_oses
lorises73918592lorises
loses56742012lo__ses
losses65925232lo_sses
lottes65322752lot_tes
lotus55718062lotu__s
louies64525102lo_uies
loupes84918052lo_upes
louse56131012lo_use_
loused74822912lo_used
lupuses936272lupuses
lususes736712lususes
momuses1159262momuses
mouses85531422mo_uses
nonuses73313862nonuses
nouses64627162no_uses
onuses65616252_onuses
opuses84012242_opuses
rouses65436282ro_uses
situses72710492situses
souses64229242so_uses
tonuses73612192tonuses
touses64229672to_uses
abortuses1144993abortuses
abuses85119103_abuses
accuses114112193accuses
amuses85117943_amuses
ankuses1148203ankuses
anuses66218773_anuses
arcuses94814693arcuses
arguses84711743arguses
arouses74921293arouses
attunes737823attunes
azotises1737603azotises
bemuses1139293bemuses
betises94816123betises
blotches1537433blotches
blotless10347143blotless
blouse84714723blo_use_
bloused104310643blo_used
blowtubes1641703blowtubes
bolases93315003bolases
boletuses1155063boletuses
bosses85925403bo_sses
botches143716023botches
bothies12414783bothies
bottles94216273bottles
boules84925973bo_ules
bourses94014303bourses
bouse75931853bo_use_
boused95322883bo_used
bowses115718863bo_wses
buses75936013__buses
cactuses1237933cactuses
causes88026473_causes
cayuses12188403cayuses
ceruses93716233ceruses
cestuses1038083cestuses
choruses1339983choruses
chouses125117813chouses
cistuses1038283cistuses
citruses1037483citruses
clauses93813323clauses
cloques18268563cloqu_es
closes85425593clo__ses
closures10228943closures
clothes124513813clot_hes
cloture9238453cloture_
clotured11246163clotured
cohunes1249713cohunes
coleuses1039713coleuses
colobuses1346133colobuses
colures9315133colures
confuses13310363confuses
contuse9311413contuse_
contused1138443contused
copses104922473co_pses
cornuses10310033cornuses
corpses113913803corpses
corpuses12310063corpuses
corses84433463co_rses
coses76949493co__ses
costumes1258013costumes
cotes76347843cot__es
cotypes1437943cotypes
coupes105022523co_upes
courses94218893courses
coutures10311973coutures
crocuses1239023crocuses
cruses88127713_cruses
cultuses1037753cultuses
cutises94414913cutises
defuses114814593defuses
delouses9310013delo_uses
disuses84015403disuses
doofuses1244283doofuses
doses65938503do__ses
dosses76126273do_sses
dotages92311793dotages
dotes65836693dot__es
dottles83912283dottles
douse66329723do_use_
doused84821163do_used
douser75621633do_user
dousers84817273do_users
dowses105718303do_wses
druses75517253_druses
dufuses11436593dufuses
ectases92911673ectases
effuses1335903effuses
entases72816273entases
enthuses1138253enthuses
estruses838483estruses
etudes73811603_etudes
excuses1638903excuses
exoduses1644803exoduses
favuses1336183favuses
ficuses12159203ficuses
flosses103411973flo_sses
flotages1237153flotages
focused13166413focused
focuser12155783focuser
focusers13134373focusers
focusses13155223focusses
fortunes1158283fortunes
fosses96022083fo_sses
fucuses12158353fucuses
fuses85628423__fuses
futures10310263futures
genuses83510883genuses
globules1135413globules
glosses84014123glo_sses
glottises1084953glottises
gooses75723053go_oses
gorses74723293go_rses
gouges86318693go_uges
grouses84616543grouses
halituses1245573halituses
hiatuses1135773hiatuses
hocused13167013hocused
hocusses13155303hocusses
hoises94823673ho_ises
horses94729343ho_rses
hoses85443173ho__ses
hotches153814363hotches
hothouses1547763hothouses
hotness1038603hotness
hotties103016953hotties
house89131423ho_use_
housed105624103ho_used
housel95217043ho_usel
housels105312133ho_usels
houser95322283ho_user
housers104717813ho_users
humuses1237593humuses
ileuses738673ileuses
incuses93514853incuses
infuses102711873infuses
iodises83413633iodises
ionises72916433ionises
joneses1438963joneses
josses135117683jo_sses
joules134116823jo_ules
jousts135011273jo_usts
ketoses114912873ketoses
lactases1038513lactases
lactoses1039813lactoses
lacunes9159623lacunes
lagunes8148523lagunes
lapises93513463lapises
lapses85217693l_apses
lases54944763l__ases
lasses64827593l_asses
latches123320123latches
latests73910313latests
latexes1438313latexes
lathes95127493lat_hes
latices9313763latices
latkes104715873lat_kes
lattes65324203lat_tes
leases65428113l_eases
lectures101310153lectures
legumes1036633legumes
lemures938793lemures
lenses64620893l_enses
leses54930813l__eses
letches124015483letches
lethes94818083let_hes
lettuces1043503lettuces
letups8317683letu_ps
leudes75314093l_eudes
lewises1039133lewises
liaises7311053liaises
ligases82310703ligases
ligules82210913ligules
ligures8269883ligures
limbuses1234903limbuses
lionises8310313lionises
lipases9209483lipases
litotes7311183litotes
litres65220393lit_res
littles73212783littles
loaches123613983loaches
loathes103513243loathes
loaves94813853lo_aves
lobbies113612463lobbies
lobes75331003lo__bes
lobule82910063lobule_
locales93715093locales
locates93218813locates
lockset13311163lockset
locksets1435693locksets
locoes85516583lo_coes
locule83412033locule_
loculed10317653loculed
loculus9296973loculus
locums10478303locu_ms
locus74819993locu__s
locust85312343locus_t
locusta9326533locusta
lodes66436913lo__des
lodges86820143lo_dges
loess55714703lo_es_s
loftless1135903loftless
loges66534203lo__ges
lollies73116923lollies
longes75925573lo_nges
longies82916553longies
loobies93814103loobies
looies65025833lo_oies
loonies73919543loonies
loose56627683lo_ose_
loosed75520893lo_osed
loosen66615963lo_osen
loosens716310953lo_osens
looser65219943lo_oser
loosest75811563lo_osest
lopes76437343lo__pes
loquats1645273loquats
lordoses937143lordoses
lores55045403lo__res
lories64933043lo_ries
lorries74518343lorries
lose45144583lo__se_
losel54419423lo__sel
losels64714583lo__sels
loser54728673lo__ser
losers65123583lo__sers
loss45337963lo__s_s
lostness837683lostness
lotahs9479873lot_ahs
lotas55926303lot__as
lotions74614763lotions
lotos54724633lot__os
lots47652093lot___s
lotte54923853lot_te_
lotted74222403lot_ted
lotter64025603lot_ter
lotters73921063lotters
lottos64613103lot_tos
louden73711793lo_uden
loudens8368053lo_udens
louder74414603lo_uder
loudest839933lo_udest
loughs105014773lo_ughs
louie55023513lo_uie_
louis57322323lo_u_is
loumas84812333lo_umas
lounges84811353lounges
loupe75319513lo_upe_
louped95316383lo_uped
loupen84510293lo_upen
loups75319623lo_u_ps
loured74617403lo_ured
lours55125293lo_u_rs
lousier72411623lo_usier
lousiest82311613lo_usiest
lousy84617083lo_us_y
louted74920693lo_uted
louts56330273lo_u_ts
louver94110393lo_uver
louvers10359103lo_uvers
louvres10356523louvres
lovages1138033lovages
loves85332013lo__ves
lowes85732463lo__wes
lowness1037813lowness
lowse87219903lo_wse_
loxes125227473lo__xes
lubes74727993l__ubes
luces75528433l__uces
ludes65728853l__udes
lues45943553l__u_es
luges65928753l__uges
lunes55337773l__unes
lunules738953lunules
lures56138533l__ures
lushes94022743l__ushes
lusts55022803l__usts
lusus54813873l__usus
lutes55836663l__utes
lutists73810273lutists
lutzes153711923lut_zes
luxes124921503l__uxes
lyases95211873l_yases
lyses84518253l__yses
matures9314303matures
meatuses1038203meatuses
minuses93512703minuses
misuses93216023misuses
mitises9315543mitises
mitoses9312183mitoses
modules102511003modules
mortises10713603mortises
mosses85527683mo_sses
motes75944003mot__es
motiles93317433motiles
motives123611893motives
mottes85523693mot_tes
mottles93415803mottles
mottoes93412193mottoes
moues75732843mo_u_es
mouse77133003mo_use_
moused94423303mo_used
mouser85822443mo_user
mousers95216443mo_users
mousey115216193mo_usey
mousse84813033mo_usse
mousses94012703mousses
mucuses11148513mucuses
muses75134303__muses
mutases92012043mutases
mutules9311843mutules
natures7311963natures
neguses837933neguses
nexuses1436743nexuses
niduses837013niduses
noctules1036583noctules
nodules8269703nodules
noises65021853no_ises
nonuse63212253nonuse_
nonuser7299143nonuser
nonusers8267993nonusers
nooses65623643no_oses
noses55435643no__ses
notates72817483notates
notches123513643notches
notes55034583not__es
notices9312283notices
oases55330983_o_ases
obtuse8147483obtuse_
obtuser9134453obtuser
obtusest1044573obtusest
oses46641513_o__ses
ostoses71213543ostoses
ousel55222403_o_usel
ousels64815273_o_usels
ousts55225703_o_usts
outsee63121803_outsee
outsees72616433_outsees
outset64027453_outset
outsets73514923_outsets
ovules938223_ovules
pauses84621473_pauses
peloruses1145873peloruses
peruses94018163peruses
plexuses1734113plexuses
plotless10256793plotless
plotties103111413plotties
plotzes18317693plot_zes
pluses83618073_pluses
poetises10313953poetises
poises84226543po_ises
poses74642763po__ses
posses85128803po_sses
postures10313763postures
potages102416423potages
potashes1337823potashes
pothouses1449043pothouses
potpies113116173potpies
potsies93019483potsies
potties93723543potties
pottles93816983pottles
protases102115033protases
proteuses11238993proteuses
ptoses83514673_ptoses
puses75532203__puses
pyloruses1443813pyloruses
rebuses94915293rebuses
recuses94619463recuses
refuses104918553refuses
retunes76918403retunes
retuse66617223retuse_
reuses66025523_reuses
rhuses94911793_rhuses
rictuses1037563rictuses
risuses73210923risuses
rogues74617673rogu_es
rooses65526233ro_oses
roques154912563roqu_es
roses56445773ro__ses
rotates72819773rotates
rotches123515703rotches
rotes56143903rot__es
rottes64524833rot_tes
roues56039353ro_u_es
rouges76022383ro_uges
rouse56634703ro_use_
roused75426443ro_used
rouser65224083ro_user
rousers75220133ro_users
rousts617016723ro_usts
routes66129313ro_utes
ruses56136583__ruses
scouses93313243scouses
sinuses73011593sinuses
soleuses838073soleuses
solutes73515263solutes
soroses73117483soroses
souse56530773so_use_
soused74822983so_used
soyuzes1932953soyuzes
spouses92912813spouses
stases64225563_stases
statuses8409533statuses
stoures74614163stoures
stupes84116953_stupes
sutures7314223sutures
taluses7311213taluses
togues76014243togu_es
tootses72910773tootses
toques154612353toqu_es
torses64727953to_rses
tortures838913tortures
tosses65225393to_sses
totes55139683tot__es
touse55430673to_use_
toused74122013to_used
tousles74113933to_usles
tubes74826453__tubes
tules54532793__tules
tunes55332193__tunes
tushes94319473__tushes
tusks94915533__tusks
tusses64921243__tusses
tuxes124316043__tuxes
untunes72211253untunes
uruses63616503_uruses
uses44931113___uses
varuses10310623varuses
venuses103111413venuses
viruses1039413viruses
vogues104011923vogu_es
volumes12298233volumes
volutes102710983volutes
vomituses1483903vomituses
votes84627083vot__es
votives13337953votives
votress1035483votress
wamuses1237023wamuses
woopses1237883woopses
worses95522953wo_rses
xeruses143010753xeruses
youse85322233yo_use_
zloties1639913zlot_ies
zonules1647793zonules

Search took 10 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274908.86015127.2
3Display Results4904900.1732832.4
 (SQL Overall)1786914909.18919446.2
 
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.