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

140 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
decos8552212(None) 
decks124822191decks
deco76125971deco_
decor84717571decor
decors94017771decors
decoy115716311decoy
decoys123911281decoys
demos86022991demos
becks135522012becks
ceros74726072ceros
cocos95624692cocos
cos510270392__cos
daces85030682daces
dados75522432dados
dagos76419442dagos
datos65222782datos
deacon9510422deacon
deacons10310392deacons
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
debs76530242de_bs
debts86418372debts
decaf114919442decaf
decafs124010882decafs
decal85523232decal
decals93717712decals
decay114718482decay
decays124612912decays
deck115827752dec_k
decoct11313782decoct
decocts1237832decocts
decode104414742decode
decodes113914982decodes
decry115514352decry
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deers64930522deers
dees56356632de_es
deets65330242deets
defis96717502defis
defog1048522defog
defogs1156682defogs
degas75119162degas
deices94119372deices
deils65722862deils
dekes105224452dekes
dekkos1034102dekkos
deles65139252deles
delfs94918672delfs
delis64928542delis
dells66630942dells
dels56745472de_ls
delts65731792delts
demes86032692demes
demo77427552demo_
demob104913502demob
demobs11429482demobs
demon86520312demon
demons94917722demons
denes65639722denes
dens55945072de_ns
dents65031802dents
depose94215762depose
depot85727922depot
depots94716342depots
derms85022892derms
desks105913072desks
detox13310952detox
deuces94015512deuces
devas96218882devas
devon95113682devon
devons104512252devons
devs86424032de_vs
dews86230602de_ws
dexes135224512dexes
deys85027472de_ys
dices86434242dices
dicks125824692dicks
dicot85429092dicot
dicots94915792dicots
didos76820812didos
dinos65428062dinos
discos94915212discos
docks126022312docks
docs75631152doc_s
dodos75819392dodos
dojos135111792dojos
dos48062312d__os
drecks13459202drecks
duces86327472duces
ducks124823212ducks
ducts85319892ducts
duos56728132d_uos
duros65422692duros
echos105216462_echos
ecus65421462_ecus
egos55821652_egos
epos66723732_epos
eros45238452_eros
feces105625362feces
fecks145417852fecks
geckos13457432geckos
gecks125117092gecks
hecks145220652hecks
helos84928062helos
heros84930862heros
jucos144111712jucos
kecks105416572kecks
kenos95220622kenos
lenos56024862lenos
locos75822602locos
memos95719112memos
necks115119332necks
pechs125516202pechs
pecks135724432pecks
pecs84634102pec_s
pepos96620082pepos
pesos77221622pesos
recks115625132recks
recon75624242recon
recons84922992recons
recs65734182rec_s
rectos85718782rectos
redos65126762redos
repos74725792repos
seccos1039922seccos
secs65033892sec_s
sects75622892sects
segos64919482segos
tacos77023552tacos
techs106915832techs
telcos8710682telcos
telos55424522telos
uncos74117032uncos
yechs136112582yechs
zeros144918102zeros
zydecos2241902zydecos

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 Filter178691538000.343520965.0
2DLD Change Limit538001405.8139255.1
3Display Results1401400.1101272.7
 (SQL Overall)1786911406.26628517.6
 
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.