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 “lotoses” 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.

464 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
lotoses7371364(None) 
looses67328241lo_oses
lotuses74011251lotuses
gooses75723052go_oses
ketoses114912872ketoses
lactoses1039812lactoses
litotes7311182litotes
locoes85516582loco_es
loesses7310032loesses
looies65025832lo_oies
loose56627682lo_ose_
loosed75520892lo_osed
loosen66615962lo_osen
loosens716310952lo_osens
looser65219942lo_oser
loosest75811562lo_osest
lordoses937142lordoses
lorises73918592lorises
loses56742012l__oses
losses65925232lo_sses
lotos54724632loto__s
lottes65322752lot_tes
louses66230282lo_uses
mitoses9312182mitoses
nooses65623642no_oses
ostoses71213542ostoses
ptoses83514672_ptoses
rooses65526232ro_oses
soroses73117482soroses
tootses72910772tootses
abioses9311493abioses
aftosas10147143aftosas
aldoses8311203aldoses
amitoses1039053amitoses
apodoses1136653apodoses
apoptoses1346443apoptoses
apposes11511473apposes
arkoses113910833arkoses
atones65225773_atones
azotises1737603azotises
bathoses13310453bathoses
betises94816123betises
bigoses1039073bigoses
biotopes1246963biotopes
blotches1537433blotches
blotless10347143blotless
blouses94014463blo_uses
bolases93315003bolases
boluses94113833boluses
bonuses94212953bonuses
boosts86115013bo_osts
bootees94114473bootees
booties94124613booties
boozes174916523bo_ozes
bosses85925403bo_sses
botches143716023botches
bothies12414783bothies
botonee9311833botonee
bottles94216273bottles
bourses94014303bourses
bouses84931783bo_uses
bowses115718863bo_wses
broses86524403_broses
chaoses124715113chaoses
chloroses1447673chloroses
chooses125717413chooses
choses115825123_choses
citoles9312553citoles
clonuses1057133clonuses
closes85425593_closes
clothes124513813clot_hes
clotures10299023clotures
cohoshes1635873cohoshes
cohosts12398803cohosts
coituses1039623coituses
cojones163512103cojones
colones96124423colones
comose105016843comose_
composes145017113composes
conioses10313313conioses
contuses10413453contuses
cooees85621893co_oees
cooties93725733cooties
copses104922473co_pses
corpses113913803corpses
corses84433463co_rses
coses76949493__coses
cosmoses1239703cosmoses
cotes76347843cot__es
cotypes1437943cotypes
courses94218893courses
coyotes12410703coyotes
cutises94414913cutises
demoses103815823demoses
deposes103117213deposes
detoxes1538803detoxes
dodoes85716103dodo_es
doses65938503__doses
dosses76126273do_sses
dotages92311793dotages
dotes65836693dot__es
dottles83912283dottles
douses74928933do_uses
dowses105718303do_wses
duotones937643duotones
ecotones1039493ecotones
ectases92911673ectases
entases72816273entases
eposes84418783_eposes
eroses65327053_eroses
ethoses10311753ethoses
exostoses1655613exostoses
exposes1639963exposes
fatsoes10379423fatsoes
fetuses10310243fetuses
flatuses1137173flatuses
floosies113210233flo_osies
flosses103411973flo_sses
flotages1237153flotages
fluoroses1244933fluoroses
focuses12159653focuses
foetuses1136083foetuses
footies103721543footies
footles103715713footles
footsies1139643footsies
fosses96022083fo_sses
fucoses12148303fucoses
globose1035543globose_
glosses84014123glo_sses
glottises1084953glottises
glucoses1145333glucoses
gnoses76515163_gnoses
goboes95914443gobo_es
goloshes1236253goloshes
goose65925903go_ose_
goosed86817033go_osed
goosey105913513go_osey
gorses74723293go_rses
halitoses1246603halitoses
heptoses1338373heptoses
hexoses17228883hexoses
hoboes114717443hobo_es
hocuses121710423hocuses
hognoses12108133hognoses
hoises94823673ho_ises
hommoses1538153hommoses
homosex1936123homosex
hooves124815483ho_oves
horses94729343ho_rses
hoses85443173__hoses
hotboxes2045063hotboxes
hotches153814363hotches
hothouses1547763hothouses
hotness1038603hotness
hotties103016953hotties
houses96032273ho_uses
ictuses938293ictuses
imposes113213683imposes
intones7816533intones
iodises83413633iodises
ionises72916433ionises
ionones7313883ionones
isotones82210433isotones
isotopes10228073isotopes
jocose1537103jocose_
joneses1438963joneses
josses135117683jo_sses
ketones115014503ketones
ketose105711813ketose_
ketosis11429733ketosis
kotos95717693koto__s
kotowed1533773kotowed
kotower1434383kotower
kotowers1534313kotowers
kotows13446513koto_ws
kurtoses12105623kurtoses
lactases1038513lactases
lactones10311223lactones
lactose969473lactose_
lanose6313593lanose_
lapises93513463lapises
lapses85217693l_apses
lases54944763l__ases
lasses64827593l_asses
lassoes74613853lassoes
latches123320123latches
latests73910313latests
latexes1438313latexes
lathes95127493lat_hes
latices9313763latices
latkes104715873lat_kes
latosol745283latosol
latosols845003latosols
lattes65324203lat_tes
leases65428113l_eases
lenses64620893l_enses
leones64417723l_eones
leses54930813l__eses
letches124015483letches
lethes94818083let_hes
leukoses1244613leukoses
lewises1039133lewises
liaises7311043liaises
ligases82310703ligases
lionises8310313lionises
lipases9209483lipases
litmuses1044463litmuses
litres65220393lit_res
littles73212783littles
loaches123613983loaches
loathes103513243loathes
loaves94813853lo_aves
lobbies113612463lobbies
lobes75331003l__obes
lobos75921843lobo__s
lobules92510813lobules
locales93715093locales
locates93218813locates
lockset13311163lockset
locksets1435693locksets
locoed94312193loco_ed
locoisms1256143locoisms
locos75822603loco__s
locules92812603locules
locusts9277933locusts
lodes66436913l__odes
lodges86820143lo_dges
loess55714703lo_es_s
loftless1135903loftless
loges66534203l__oges
logons79818173logo_ns
logos67225333logo__s
lollies73116923lollies
longes75925573lo_nges
longies82916553longies
loobies93814103loobies
looed64626133lo_o_ed
looey84822913lo_o_ey
looeys95110123lo_oeys
loofas9429833lo_ofas
loofs85623783lo_o_fs
looie55624243lo_oie_
looked114717073lo_oked
looker104816953lo_oker
lookers114014073lo_okers
looks95124863lo_o_ks
loomed94616763lo_omed
looms75124643lo_o_ms
looney94712403lo_oney
looneys10487013lo_oneys
loonies73919543loonies
loons55731723lo_o_ns
looped95217173lo_oped
looper83817113lo_oper
loopers93914033lo_opers
loops75723963lo_o_ps
loos49051123lo_o__s
loosely1036713lo_osely
looted74421113lo_oted
looter64222323lo_oter
looters74419163looters
loots55431423lo_o_ts
lopes76437343l__opes
lordosis944453lordosis
lores55045403l__ores
lories64933043lo_ries
lorries74518343lorries
lose45144583l__ose_
losel54419423l__osel
losels64714583l__osels
loser54728673l__oser
losers65123583l__osers
loss45337963l__os_s
lostness837683lostness
lotahs9479873lot_ahs
lotas55926303lot__as
lotions74614763lotions
lots47652093lot___s
lotte54923853lot_te_
lotted74222403lot_ted
lotter64025603lot_ter
lotters73921063lotters
lottos64613103lot_tos
lotus55718063lot__us
louies64525103lo_uies
lounges84811353lounges
loupes84918053lo_upes
louse56131013lo_use_
loused74822913lo_used
louvres10356523louvres
lovages1138033lovages
loves85332013l__oves
lowes85732463l__owes
lowness1037813lowness
lowse87219903lo_wse_
loxes125227473l__oxes
lupuses936273lupuses
lususes736713lususes
lutes55836663lut__es
lutists73810273lutists
lutzes153711923lut_zes
lyases95211873l_yases
lyses84518253l__yses
maltoses1039853maltoses
meioses9310833meioses
metopes11311363metopes
mioses84318853_mioses
mitises9315533mitises
mitosis939633mitosis
mojoes15399523mojo_es
momuses1159263momuses
moose76327193mo_ose_
mopokes1536693mopokes
morose85116243morose_
mortises10713603mortises
mosses85527683mo_sses
motes75944003mot__es
motiles93317433motiles
motives123611893motives
motored1039933motored
motorises11311663motorises
motors84616593moto_rs
mottes85523693mot_tes
mottles93415803mottles
mottoes93412193mottoes
mouses85531423mo_uses
mousses94012703mousses
mutases92012043mutases
mycoses1437723mycoses
myoses114013843_myoses
myotomes1546233myotomes
nodose738883nodose_
noises65021853no_ises
nonuses73313863nonuses
noose55624063no_ose_
noosed75018013no_osed
nooser65517823no_oser
noosers74913903no_osers
noses55435643__noses
notates72817483notates
notches123513643notches
notes55034583not__es
notices9312283notices
nouses64627163no_uses
oases55330983_o_ases
oboes75717713_obo_es
oboles83815833_oboles
olorosos844103olorosos
onuses65616253_onuses
oozes145418713_o_ozes
opposes1149243opposes
opuses84012243_opuses
orthoses11311123orthoses
oses46641513___oses
osmoses9138123osmoses
osteoses839033osteoses
ostosis71310113ostosis
otiose639403_otiose_
ozones1539393_ozones
pathoses13412763pathoses
pentoses10312893pentoses
photoset13414273photoset
photosets1447813photosets
plotless10256793plotless
plotties103111413plotties
plotzes18317693plot_zes
pocosen1146833pocosen
pocosens1255253pocosens
poetises10313953poetises
poises84226543po_ises
pooves113914713po_oves
porose84818743porose_
poses74642763__poses
posoles9314883posoles
posses85128803po_sses
postposes1348183postposes
potages102416423potages
potashes1337823potashes
potholes13312933potholes
pothouses1449043pothouses
potpies113116173potpies
potsies93019483potsies
potties93723543potties
pottles93816983pottles
pozoles1839063pozoles
proposes122515973proposes
proptoses1349873proptoses
proses84733473_proses
protases102115033protases
proteoses112211013proteoses
ptosis83611823_ptosis
pyoses114314303_pyoses
reposes94021263reposes
riboses9310443riboses
roose56127093ro_ose_
roosed75621593ro_osed
rooser63921883ro_oser
roosers74217873ro_osers
roosts64916323ro_osts
rootles73215633rootles
roses56445773__roses
rotates72819773rotates
rotches123515703rotches
rotes56143903rot__es
rotors64917933roto_rs
rotos56027883roto__s
rottes64524833rot_tes
rouses65436283ro_uses
saroses73619333saroses
setose65114773setose_
situses72710493situses
soothes103917103soothes
sorboses1038523sorboses
sorosis72611963sorosis
sotols63714453soto_ls
souses64229243so_uses
stases64225563_stases
stokes104821793_stokes
stoles63927673_stoles
stones65130033_stones
stooges83611483stooges
stopes84525893_stopes
stores65533643_stores
stoss54316343_stos_s
stoves93818923_stoves
sycoses1249133sycoses
toes46956443__to_es
tokes95234973__tokes
toles55147133__toles
tomes76037383__tomes
tones56048663__tones
tonuses73612193tonuses
tootles72915603tootles
tootsies848613tootsies
topes76941763__topes
tores55352673__tores
torose64317693torose_
torses64727953to_rses
tortoises947183tortoises
toshes94520103__toshes
toss45637973__tos_s
tosses65225393to_sses
totes55139683__totes
touses64229673to_uses
trioses75015643trioses
unlooses8127293unlo_oses
uptoss836093uptos_s
uptosses1043973uptosses
vamoses1239143vamoses
vetoes92914083veto_es
viroses10310533viroses
volosts1036563volosts
votes84627083vot__es
votives13337953votives
votress1035483votress
woopses1237883woopses
wooshes13169883wo_oshes
worses95522953wo_rses
xeroses143612823xeroses
xyloses1746843xyloses
zloties1639913zlot_ies
zoonoses1746203zoonoses
zygoses20436783zygoses
zymoses21608693zymoses

Search took 7 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.1531167915.0
2DLD Change Limit1340274646.03322215.6
3Display Results4644640.1732682.1
 (SQL Overall)1786914646.35928100.5
 
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.