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 “locos” 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
locos7582260(None) 
cocos95624691cocos
lobos75921841lobos
lochs106715511lochs
locks115126921locks
loco67030741loco_
locoes85516581locoes
locus74819991locus
logos67225331logos
loos49051121lo_os
lotos54724631lotos
blocks144513942blocks
blocs95219652bloc_s
bocks134526572bocks
bohos105618252bohos
bolos75531372bolos
boos67955032bo_os
boyos105418282boyos
bozos165216862bozos
clocks144916232clocks
cocas95926572cocas
cocks135227162cocks
coco87330602coco_
cocoa98517882cocoa
cocoas104915742cocoas
cohos105921852cohos
coos67456492co_os
cos510270392__cos
decos85522122decos
docks126022312docks
docs75631152doc_s
dodos75819392dodos
dojos135111792dojos
flocks154713532flocks
flocs105519232floc_s
focus105815882focus
gobos86219372gobos
gogos77516522gogos
goos57644912go_os
hobos106321352hobos
hocks144925492hocks
hocus104715202hocus
homos105921782homos
jockos19527562jockos
jocks185118082jocks
jocose1537102jocose
jucos144111712jucos
kobos115616892kobos
kolos94921212kolos
kotos95717692kotos
laces76141762laces
lacks116129202lacks
lacs66942482lac_s
lenos56024862lenos
licks115325392licks
lidos65219882lidos
lilos55821872lilos
limos75320812limos
linos55631502linos
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
lobes75331002lobes
lobo67229862lobo_
lobs66441082lo_bs
loca65527682loc_a
local74820272local
locals83714502locals
loch95527132loc_h
loci66126282loc_i
lock106134362loc_k
locoed94312192locoed
locoism1156792locoism
locum94812172locum
locums10478302locums
locust85312342locust
lodes66436912lodes
loess55714702loess
lofts85518362lofts
loges66534202loges
logo57931762logo_
logoi69715942logoi
logon615922312logon
logons79818172logons
logs57343112lo_gs
loids66220702loids
loins56728422loins
lolls512121732lolls
longs65527062longs
loo38359822lo_o_
loof78141052lo_of
loofs85623782loofs
look87333472lo_ok
looks95124862looks
loom67035052lo_om
looms75124642looms
loon47344792lo_on
loons55731722loons
loop67835012lo_op
loops75723962loops
loose56627682lo_ose
loot46955822lo_ot
loots55431422loots
lopes76437342lopes
lops66043352lo_ps
lords64923502lords
lores55045402lores
loris55329152loris
loses56742012loses
loss45337962lo_ss
lotas55926302lotas
lots47652092lo_ts
lottos64613102lottos
lotus55718062lotus
louis57322322louis
loups75319622loups
lours55125292lours
louts56330272louts
loves85332012loves
lowes85732462lowes
lows75843012lo_ws
loxes125227472loxes
luces75528432luces
lucks115723562lucks
mocks135023822mocks
mocs85834902moc_s
mojos145314462mojos
monos75930862monos
moos66051302mo_os
mozos165516332mozos
nocks115121012nocks
nolos54423352nolos
nomos75919742nomos
ocas66729632_ocas
oleos55419682oleos
olios54520852olios
onos46229002_onos
pocks135022962pocks
poco86826152poco_
polos76129912polos
pomos95321582pomos
poos65949112po_os
rocks114626412rocks
rocs65533662roc_s
rotos56027882rotos
socas74026182socas
socks114926082socks
solos54830792solos
tacos77023552tacos
topos75726392topos
toros54336192toros
toyos87519142toyos
uncos74117032uncos
voces105918052voces
woos76238802wo_os
yocks144418372yocks
zoos135828802zo_os

Search took 3 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.186960704.3
2DLD Change Limit538001582.14325105.0
3Display Results1581580.0463434.8
 (SQL Overall)1786911582.37575238.3
 
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.