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

148 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
demos8602299(None) 
decos85522121decos
demes86032691demes
demo77427551demo_
demob104913501demob
demobs11429481demobs
demon86520311demon
demons94917721demons
memos95719111memos
ammos94815822ammos
bemas96424282bemas
camos95927612camos
ceros74726072ceros
chemos13311722chemos
dados75522432dados
daemon9279592daemon
daemons10269232daemons
dagos76419442dagos
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372dam_s
datos65222782datos
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
debs76530242de_bs
debts86418372debts
decks124822192decks
deco76125972deco_
decor84717572decor
decors94017772decors
decoy115716312decoy
decoys123911282decoys
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deers64930522deers
dees56356632de_es
deets65330242deets
defis96717502defis
defog1048522defog
defogs1156682defogs
degas75119162degas
deils65722862deils
dekes105224452dekes
dekkos1034102dekkos
deles65139252deles
delfs94918672delfs
delis64928542delis
dells66630942dells
dels56745472de_ls
delts65731792delts
demast9517062demast
deme76536282dem_e
demic105119192demic
demies94825802demies
demise94618322demise
demit84832302demit
demits94918072demits
demode104013462demode
demoed103713442demoed
demoses103815822demoses
demote94817802demote
demotes104717672demotes
demur8311162demur
demurs939772demurs
demy105422852dem_y
denes65639722denes
dens55945072de_ns
dents65031802dents
depose94215762depose
depot85727922depot
depots94716342depots
dermas94116812dermas
dermis94717162dermis
derms85022892derms
desks105913072desks
detox13310952detox
devas96218882devas
devon95113682devon
devons104512252devons
devs86424032de_vs
dews86230602de_ws
dexes135224512dexes
deys85027472de_ys
didos76820812didos
dimes85833042dimes
dims75435022dim_s
dinos65428062dinos
dodos75819392dodos
dojos135111792dojos
domes85735562domes
doms76239572dom_s
dooms85321342dooms
dos48062312d__os
dumas85420432dumas
dumbos114111082dumbos
dumbs105915752dumbs
dumps105220102dumps
duomos936822duomos
duos56728132d_uos
duros65422692duros
edemas9310502edemas
egos55821652_egos
emes65434662_emes
ems56435492_em_s
emus66821682_emus
epos66723732_epos
eros45238452_eros
femes105626222femes
fems96428702fem_s
gemot84024232gemot
gemots93712152gemots
gems75329112gem_s
helos84928062helos
hemes105031082hemes
hemps126917332hemps
hems95534942hem_s
heros84930862heros
homos105921782homos
kemps135012522kemps
kenos95220622kenos
lemon75618182lemon
lemons84415052lemons
lenos56024862lenos
limos75320812limos
memes94927702memes
memo85924792memo_
mems85931502mem_s
mos57067122__mos
nemas75321572nemas
nomos75919742nomos
pepos96620082pepos
pesos77221622pesos
pomos95321582pomos
redos65126762redos
rems66237722rem_s
repos74725792repos
segos64919482segos
semes75731582semes
semis74623532semis
sumos75720092sumos
telos55424522telos
tempos103812292tempos
temps95417132temps
zeros144918102zeros

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.0802233637.5
2DLD Change Limit538001481.67032215.6
3Display Results1481480.0463217.4
 (SQL Overall)1786911481.79699493.9
 
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.