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

204 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
memoirs113680(None) 
memoir1037211memoir_
devoirs1175782devoirs
emirs76116162_em_irs
meloids10911452meloids
members13258602members
memoirist1345982memoirist
memories121214352memories
memorise121411432memorise
memory1338802memo_ry
memos95719112memo__s
menhirs1235912menhirs
amirs75924923_am_irs
amours83512663_amours
armoire938133armoire
armoires1057623armoires
armors85017813armo_rs
armours9389853armours
bemire103312803bem_ire
bemires113212833bem_ires
bemoans1138253bemoans
bemocks1735373bemocks
bestirs9311133bestirs
bevors111610343bevo_rs
bezoars1836793bezoars
ceboids1237653ceboids
choirs114911883_choirs
coirs75221053__coirs
deairs74013783de_airs
decors94017773deco_rs
demies94825803dem_ies
demits94918073dem_its
demobs11429483demo_bs
demoing11311753demoing
demons94917723demo_ns
demos86022993demo__s
demoses103815823demoses
demotes104717673demotes
demotics1338753demotics
demurs939773dem_urs
dermoids1246163dermoids
desmoids1244973desmoids
detours858043detours
devoir1076033devoir_
devours1166643devours
eloins65419383_eloins
emails84412343_emails
embars103812883_embars
embers104116183_embers
emeers83314183_emeers
emeroids11147723emeroids
emir65918703_em_ir_
emits75421473_em_its
emmers104013223_emmers
emodins1039433_emodins
emoters94712873_emoters
emotes84620283_emotes
empire1039323_empire
empires1139853_empires
femora1149583femo_ra
femurs1136713fem_urs
fetors91014473feto_rs
gambirs12359083gambirs
gemotes103712143gemotes
gemots93712153gemo_ts
geoids8369843ge_oids
heirs85618563he__irs
hemins113417563hem_ins
hemmers143310843hemmers
hemoid12313513hemoi_d
heroics122912003heroics
heroins103518013heroins
humors11129633humo_rs
humours1286433humours
jemmies18318333jemmies
kefirs13396653ke_firs
keirs95313673ke__irs
keloids1288663keloids
lemons84415053lemo_ns
lempira1144193lempira
lempiras1243853lempiras
lemurs837253lem_urs
maftirs1236043maftirs
mairs76228303__mairs
majors154511093majo_rs
mamies104626243mam_ies
mammers104615693mammers
mammies104314763mammies
mamzers20409163mamzers
manors84420883mano_rs
mayors115714193mayo_rs
mealies92821933mealies
meaners94415243meaners
meanies93620743meanies
medias93620783me_dias
medics114115353me_dics
medius93613283me_dius
medlars10259443medlars
meeters94714543meeters
megohms1592863megohms
megrims1276103megrims
meinies92516073meinies
meioses9310833meioses
meiosis939023meiosis
melders103213913melders
melodias1148703melodias
melodies11310123melodies
meloid9616003meloi_d
melons84117713melo_ns
melters93918313melters
member12258853member_
memes94927703mem__es
memetics1447803memetics
memo85924793memo___
memoirists1444133memoirists
memorial1249523memorial
memorials1346553memorials
memorised14118223memorised
memorises131211583memorises
memorize211311103memorize
memorizers23125003memorizers
memorizes221310823memorizes
mems85931503mem___s
menders103818803menders
menhir1136783menhir_
mentors9314993mentors
meous76120063me_o_us
meows104612683me_o_ws
mercers114412773mercers
mercies113817563mercies
mergers103813423mergers
merits8320873me_rits
merlins93015813merlins
mermaids1355753mermaids
meropias1249963meropias
mesons83215843meso_ns
meteors94610013meteors
meters85625833me_ters
metiers93312843metiers
metis75025903me_ti_s
metols84115773meto_ls
metopes11311363metopes
metrics11312363metrics
mewlers12288983mewlers
midairs1037203midairs
mimbars1397383mimbars
mimers105520183mim_ers
mimics1289363mim_ics
mimosas1136753mimosas
minors85117103mino_rs
mirs66940573__m_irs
mnemonics1543313mnemonics
mohairs1234953mohairs
moils76125753__moils
moira71012023__moira
moire71017323__moire
moires8915633__moires
mommies103912273mommies
momsers113810843momsers
momzers20367133momzers
moors74923143__moors
mors65950063__mo_rs
motors84616603moto_rs
mucoids1237423mucoids
mucors104410853muco_rs
mummers103712843mummers
mummies103812843mummies
mumpers133311373mumpers
noirs55615463__noirs
reboils94111723reboils
recoils93814873recoils
recoins94019243recoins
rejoins143111383rejoins
remails94714563remails
remains94117903remains
remiss84216353rem_iss
remits85622943rem_its
remolds10299703remolds
remora8414593remo_ra
remoras9314073remoras
remorid10311863remorid
remorse9311713remo_rse
remotes94521613remotes
removers13449223removers
removes124514713removes
reoils64516873re_oils
repairs9319973repairs
repours9310233repours
rumors81110403rumo_rs
rumours976373rumours
semis74623533sem_i_s
seniors73413623seniors
senors63620793seno_rs
tempers113513013tempers
tenors63217753teno_rs
tenours72610073tenours
termors94712773termo_rs
tremors93711233tremo_rs
tumors8810613tumo_rs
tumours976753tumours
unmoors945903unmoors
velours10278083velours
vetoers10359473vetoers
weirs84316493we__irs

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272046.90619407.3
3Display Results2042040.0762684.2
 (SQL Overall)1786912047.37224239.1
 
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.