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

114 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
merde8432012(None) 
merdes94518601merdes
mere67244441mer_e
merge84523681merge
merle75824371merle
aerie54634602aerie
amerce10310512amerce
barde85330772barde
berme96022942berme
brede85520502brede
cede74928762ce_de
cere66741472cer_e
cered85227442cered
dere56845902der_e
deride84420032deride
eerie55228532eerie
eide55832232_eide
emerge91510462emerge
emyde1136382emyde
ere36352772_er_e
erne46727422_erne
erode64520992_erode
fere76342232fer_e
geode7412592geode
herd84933062herd_
herded114215642herded
herder104516462herder
herds96424682herds
here76447102her_e
horde94623052horde
kerne94718212kerne
made75440232m_ade
madre85720172madre
mare64759322mar_e
marge85328332marge
marse76231152marse
mead75531602mead_
meads85425322meads
med66146742me_d_
meddle103312762meddle
meds75735362me_ds
meed74934702meed_
meeds84920272meeds
meld75830472meld_
melded104714712melded
melder93915812melder
melds84822382melds
melee73729102melee
meme85330552me_me
mend75334022mend_
mended104418682mended
mender93520792mender
mends84927692mends
mense75025632mense
merc87225622mer_c
mercer105214202mercer
merces105720742merces
merch125417962merch
mercs96020452mercs
mercy125916182mercy
merer75126232merer
meres75143572meres
merged104214942merged
mergee94018132mergee
merger95016472merger
merges94122482merges
merit7339182merit
merk106027942mer_k
merks114722402merks
merl65830972mer_l
merles85322762merles
merls77423902merls
mermen10813812mermen
merry104721482merry
mesne75116292mesne
mete64438132me_te
meted85424432meted
metre74821302metre
metred95315142metred
mewed115218012mewed
meze154420902me_ze
mire66748232mir_e
mired85729222mired
mode75840302m_ode
monde85723142monde
morae75831192morae
more67154522mor_e
morse76032702morse
murder93613782murder
mure65941332mur_e
mured85726702mured
murre74821072murre
nerd56624942nerd_
nerds65719252nerds
nerdy95014702nerdy
nerve86617372nerve
perdie94718512perdie
perdu84216272perdu
perdue93912632perdue
perdy115417322perdy
pere66450262per_e
perse75429522perse
rede55037662re_de
sere46153472ser_e
sered65737292sered
serge64727462serge
serve85425962serve
terce75721842terce
terne56426152terne
terse55026822terse
verge93419832verge
verse84723582verse
verve115417722verve
were76238332wer_e

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.0931921408.6
2DLD Change Limit538001141.44037361.1
3Display Results1141140.0303800.0
 (SQL Overall)1786911141.563114325.7
 
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.