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

158 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
loess5571470(None) 
less45635101l_ess
loses56742011loses
loss45337961lo_ss
aloes54933672aloe_s
bless75917812bless
boss65938342bo_ss
cess65326052_cess
chess105016922chess
closes85425592closes
coeds85920162coeds
coses76949492coses
coss66143492co_ss
cress75022832cress
doers65225712doers
does56554472doe_s
doest65829522doest
doses65938502doses
doss56235042do_ss
dress65319832dress
ess36030882__ess
fess76529162_fess
floes85528142floe_s
floss85118262flo_ss
foes76543442foe_s
foss76431642fo_ss
gloss64319622glo_ss
goers65520252goers
goes55644092goe_s
guess64213362guess
hoers85724922hoers
hoes75755732hoe_s
hoses85443172hoses
jess116022032_jess
joes116635892joe_s
joeys15518042joeys
joss115925592jo_ss
koels94613902koels
koss85224812ko_ss
lases54944762lases
lass47444542l_ass
leas45954182l_eas
leeks95318892leeks
leers54828982leers
lees45455882l_ees
leets54927122leets
legs56133692l_egs
leis45739602l_eis
leks85427602l_eks
lens46146492l_ens
les35663072l_e_s
leses54930812l_eses
lest46956322l_est
lets47147942l_ets
leys76430182l_eys
liens56525502liens
liers55130402liers
lies46454192lie_s
lieus56218482lieus
lioness739102lioness
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
lobes75331002lobes
lobos75921842lobos
lobs66441082lo_bs
lochs106715512lochs
locks115126922locks
locos75822602locos
locus74819992locus
lodens74315062lodens
lodes66436912lodes
loessal744392loessal
loesses7310032loesses
lofts85518362lofts
loges66534202loges
logos67225332logos
logs57343112lo_gs
loids66220702loids
loins56728422loins
lolls512121732lolls
loners64225812loners
longs65527062longs
looeys95110122looeys
loofs85623782loofs
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122lo_os
loose56627682loose
looses67328242looses
loots55431422loots
lopers84424142lopers
lopes76437342lopes
lops66043352lo_ps
lords64923502lords
lores55045402lores
loris55329152loris
lose45144582lo_se
losel54419422losel
losels64714582losels
loser54728672loser
losers65123582losers
losses65925232losses
lossy85214642lossy
lost47951492lo_st
lotas55926302lotas
lotos54724632lotos
lots47652092lo_ts
lotus55718062lotus
louis57322322louis
loups75319622loups
lours55125292lours
louse56131012louse
louses66230282louses
lousy84617082lousy
louts56330272louts
lovers94223432lovers
loves85332012loves
lowers94624922lowers
lowes85732462lowes
lowest93915592lowest
lowness1037812lowness
lows75843012lo_ws
lowse87219902lowse
loxes125227472loxes
lues45943552lue_s
lweis8458692lweis
lyes75530832lye_s
lyses84518252lyses
mess65932432_mess
moss67641032mo_ss
ness45526562_ness
noels56418702noels
noes45845392noe_s
noesis6311442noesis
noses55435642noses
oes35866192_oe_s
oleos55419682oleos
oles46453472ole_s
oses46641512_oses
poems95715552poems
poesy105014062poesy
poets76024442poets
poses74642762poses
press75425952press
roes45954142roe_s
roses56445772roses
sloes54728872sloe_s
toeas55726422toeas
toes46956442toe_s
toss45637972to_ss
tress55423162tress
voes75432822voe_s
woes76440662woe_s
zoeas145815612zoeas

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.296603685.8
2DLD Change Limit538001581.40638264.6
3Display Results1581580.0463434.8
 (SQL Overall)1786911581.748102226.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.