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

124 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
memos9571911(None) 
demos86022991demos
memes94927701memes
memo85924791memo_
mems85931501mem_s
ammos94815822ammos
bemas96424282bemas
camos95927612camos
ceros74726072ceros
chemos13311722chemos
decos85522122decos
demes86032692demes
demo77427552demo_
demob104913502demob
demobs11429482demobs
demon86520312demon
demons94917722demons
egos55821652_egos
emes65434662_emes
emmys12446022emmys
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
makos116518362makos
mamas95930772mamas
mambos125414492mambos
manos74933622manos
mayos105521932mayos
meads85425322meads
meals75933372meals
means75831232means
meats75034052meats
meds75735362me_ds
meeds84920272meeds
meets74224612meets
megs75530632me_gs
melds84822382melds
mells75031332mells
melon73922082melon
melons84117712melons
mels65941532me_ls
melts74930102melts
mem77943472mem__
meme85330552mem_e
memoir1037212memoir
memoirs1136802memoirs
memory1338802memory
mends84927692mends
meno66031362meno_
menus75822842menus
meou65325862me_ou
meous76120062meous
meow95117882me_ow
meows104612682meows
mercs96020452mercs
meres75143572meres
merks114722402merks
merls77423902merls
mesas76823202mesas
meson74118312meson
mesons83215842mesons
mess65932432me_ss
metes74736212metes
meths105320232meths
metis75025902metis
metol75917812metol
metols84115772metols
metros84217802metros
mewls105813232mewls
mews96629332me_ws
mezes167719262mezes
mezzos1635052mezzos
mhos95517772m_hos
milos75428012milos
mimeos104511542mimeos
mimes95732022mimes
mimosa1036362mimosa
misos76523292misos
mojos145314462mojos
momes95134472momes
moms86539482mom_s
momus96116112momus
monos75930862monos
moos66051302m_oos
mos57067122__mos
mozos165516332mozos
mumms85513152mumms
mumps115619102mumps
mums85732772mum_s
mumus95517282mumus
nemas75321572nemas
nomos75919742nomos
pepos96620082pepos
pesos77221622pesos
pomos95321582pomos
redos65126762redos
rems66237722rem_s
repos74725792repos
segos64919482segos
semes75731582semes
semis74623532semis
sumos75720092sumos
telos55424522telos
tempos103812292tempos
temps95417132temps
zeros144918112zeros

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 Limit538001241.65332546.9
3Display Results1241240.0333757.6
 (SQL Overall)1786911241.766101184.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.