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

142 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
kotos9571770(None) 
kobos115616891kobos
kolos94921211kolos
koto86323471koto_
kotow12528711kotow
kotows13446521kotows
lotos54724631lotos
rotos56027881rotos
altos55822952altos
autos56523322autos
bohos105618252bohos
bolos75531372bolos
boos67955032bo_os
boots75837972boots
botas75328782botas
bots66453952bot_s
botts75224862botts
boyos105418282boyos
bozos165216862bozos
cocos95624692cocos
cohos105921852cohos
contos84923232contos
coos67456492co_os
coots75636842coots
cotes76347842cotes
cots68054842cot_s
datos65222782datos
dodos75819392dodos
dojos135111792dojos
dotes65836692dotes
dots55647662dot_s
foots85528282foots
gobos86219382gobos
gogos77516522gogos
goos57644912go_os
goths96513002goths
hobos106321352hobos
homos105921782homos
hoots84830252hoots
hots78349332hot_s
iotas54821112iotas
jatos125116822jatos
jotas125717442jotas
jots116336142jot_s
katas95922092katas
kats85944332kat_s
kayos127714702kayos
kenos95220622kenos
keto86223452keto_
ketol95414002ketol
ketols104210762ketols
ketose105711812ketose
kilos95021472kilos
kinos96626142kinos
kites95432542kites
kiths125814972kiths
kits86441772kit_s
knots95614722knot_s
koans95818622koans
koas85635092ko_as
kobo107422102kobo_
kobs105831082ko_bs
koels94613902koels
kohls12437802kohls
kois85129402ko_is
kojis16468442kojis
kolas94822232kolas
kolo87026222kolo_
konks84917112konks
kook75822602ko_ok
kooks85217262kooks
kophs145010932kophs
kops107031292ko_ps
koras95927112koras
kors85933012ko_rs
kos76944822k__os
koss85224812ko_ss
kouros1039182kouros
kowtow1643462kowtow
kowtows1742762kowtows
kudos105011252kudos
kytes125012912kytes
lobos75921842lobos
locos75822602locos
logos67225332logos
loos49051122lo_os
loots55431422loots
lotas55926302lotas
lots47652092lot_s
lottos64613102lottos
lotus55718062lotus
mojos145314462mojos
monos75930862monos
moos66051302mo_os
moots75831662moots
motes75944002motes
moths106021552moths
motor75317292motor
motors84616602motors
mots66853162mot_s
mottos84615242mottos
motts76527002motts
mozos165516332mozos
nolos54423352nolos
nomos75919742nomos
notes55034582notes
onos46229002_onos
oots46446442oot_s
ottos54714322ottos
photos113316642photos
polos76129912polos
pomos95321582pomos
poos65949112po_os
pothos114214692pothos
pots66452362pot_s
pottos84615872pottos
ratos55528762ratos
roots55933672roots
rotas54827722rotas
rotes56143902rotes
rotis56327062rotis
rotls55620162rotls
roto45935052roto_
rotor55519732rotor
rotors64917952rotors
rots46454092rot_s
solos54830792solos
soots55536212soots
soths86218632soths
sotol54917652sotol
sotols63714472sotols
sots45552452sot_s
toots55331872toots
topos75726392topos
toros54336192toros
totes55139682totes
tots46654122tot_s
toyos87519142toyos
votes84627082votes
woos76238802wo_os
wots76342892wot_s
zoos135828802zo_os

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 Limit538001421.59633709.3
3Display Results1421420.0463087.0
 (SQL Overall)1786911421.93892203.8
 
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.