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 “memoir” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

239 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
memoir103721(None) 
memoirs1136801memoirs
devoir1076032devoir
emir65918702_em_ir
hemoid12313512hemoid
meloid9616002meloid
member12258852member
memo85924792memo__
memory1338802memory
memos95719112memo_s
menhir1136782menhir
ameboid1277233ameboid
amir65129753_am_ir
amour75014853_amour
armoire938133armoire
armor75118053armo_r
armour84411853armour
bemire103312803bem_ire
bemix165011453bem_ix
bemoan10310253bemoan
bemock1636173bemock
bestir8311163bestir
bevor101510813bevo_r
bezoar1736913bezoar
ceboid11310653ceboid
choir105313603_choir
coir66327243__coir
cymoid1459473cymoid
deair65817193de_air
decor84717573deco_r
demic105119193dem_ic
demit84832303dem_it
demo77427553demo__
demob104913503demo_b
demobs11429483demobs
demode104013463demode
demoed103713443demoed
demoing11311753demoing
demon86520313demo_n
demonic12311223demonic
demons94917723demons
demos86022993demo_s
demote94817803demote
demotic12412353demotic
demur8311163dem_ur
dermoid1138523dermoid
desmoid1137103desmoid
detour778193detour
devoid1189363devoid
devoirs1175783devoirs
devour1076703devour
eloin55923203_eloin
email74715103_email
embar94011603_embar
ember95516803_ember
emeer74815363_emeer
emeroid101511183emeroid
emic86422753_em_ic
emirs76116163_em_irs
emit65438423_em_it
emmer94314463_emmer
emodin9310353_emodin
emote75421193_emote
emoter85415193_emoter
empire1039323_empire
eyrir8359653_eyrir
femora1149583femora
femur1038683fem_ur
fetor81214533feto_r
gambir11509773gambir
gemmier12337383gemmier
gemot84024233gemo_t
gemote94613023gemote
gemots93712153gemots
geoid74215763ge_oid
haemoid1337203haemoid
heir77523803he__ir
hemic125718623hem_ic
hemin103620933hem_in
hemmer134112643hemmer
hempie132410563hempie
hempier14319003hempier
heroic113516923heroic
heroin94420593heroin
humor101110513humo_r
humour11116753humour
kefir12457913ke_fir
keir86217873ke__ir
keloid11812623keloid
lemon75618183lemo_n
lemons84415053lemons
lemony11419553lemony
lempira1144193lempira
lemur739773lem_ur
maftir1136493maftir
mair66133783__mair
major145212923majo_r
mamie95826003mam_ie
mammer94218863mammer
mammie94313783mammie
mamzer19459833mamzer
manor78023933mano_r
mayor106616623mayo_r
meager94515203meager
mealie82519813mealie
mealier93015903mealier
meaner84617843meaner
meanie83718393meanie
meatier93214613meatier
media84721713me_dia
medic104619653me_dic
medii84513493me_dii
medlar93010463medlar
meeker12359983meeker
meeter83616503meeter
megohm14124193megohm
megrim1178043megrim
meinie82614523meinie
meiosis939023meiosis
meiotic11410933meiotic
melder93915813melder
melic94722333me_lic
melodia1038883melodia
melodic1238543melodic
melody1237203melody
meloids10911453meloids
melon73922083melo_n
melons84117713melons
melter83520113melter
mem77943473mem___
members13258603members
meme85330553mem__e
memes94927703mem_es
memoirist1345983memoirist
memorial1249523memorial
memories121214353memories
memorise121411433memorise
memoriter13126573memoriter
memorize211311103memorize
memorizer22137643memorizer
mems85931503mem__s
mender93520793mender
menhirs1235913menhirs
meno66031363meno__
mentor8414363mentor
meou65325863me_o_u
meous76120063me_ous
meow95117883me_o_w
meows104612683me_ows
mercer105214203mercer
merer75126233me_rer
merger95016483merger
merit7339183me_rit
merlin83916683merlin
mermaid1297853mermaid
meropia1149613meropia
meropic13310263meropic
merrier92612303merrier
meshier123410853meshier
mesic93617863me_sic
meson74118313meso_n
mesonic11310093mesonic
mesons83215843mesons
messier93412923messier
meteor84910073meteor
meter75130323me_ter
metier83517693metier
metis75025903me_tis
metol75917813meto_l
metols84115773metols
metope10611123metope
metopic1339763metopic
metric10314683metric
mewler113510233mewler
midair937993midair
mimbar1297493mimbar
mimer94825763mim_er
mimic111414323mim_ic
mimosa1036363mimosa
minor74920063mino_r
mir57046773__m_ir
mnemonic1445233mnemonic
mohair1135203mohair
moil65534093__moil
moira71012023__moira
moire71017323__moire
momi87524483mom_i_
momser104011413momser
momzer19327553momzer
moor66628553__moor
mor56855003__mo_r
motor75317293moto_r
mucoid1139783mucoid
mucor94011943muco_r
mummer93614543mummer
mumper123513523mumper
myeloid13108123myeloid
myoid11512993m_yoid
myxoid1936883myxoid
nevoid1098793nevoid
noir46722433__noir
nomoi76012533nomoi_
reboil83814683reboil
recoil84016723recoil
recoin84320293recoin
rejoin134012243rejoin
remail85017123remail
remain85919863remain
remit75737223rem_it
remix145916553rem_ix
remold93412973remold
remora8414593remora
remorid10311863remorid
remote84222603remote
remoter94815973remoter
remove116115573remove
remover124612273remover
reoil55321183re_oil
repair84011463repair
repour8310993repour
rumor71011323rumo_r
rumour8127383rumour
semi65127223sem_i_
semis74623533sem_is
senior63214053senior
senor53822803seno_r
teloi54217383teloi_
temper103914093temper
tempi94912203tempi_
tenor53620253teno_r
tenour62610733tenour
termor84412513termo_r
tremor84210403tremo_r
tumor71110693tumo_r
tumour8137403tumour
unmoor836313unmoor
velour9328763velour
vetoer93410063vetoer
weir76019923we__ir

Search took 8 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 Filter1786911127160.453394461.4
2DLD Change Limit1127162396.67316891.4
3Display Results2392390.483494.8
 (SQL Overall)1786912397.60923484.2
 
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.