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

209 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
mercery1439762(None) 
mercer105214201mercer_
mercers114412771mercers
mercury14364891mercury
amercer1146372amercer_
amercers1256132amercers
fernery1335812fernery
mercenary1643352mercenary
merces105720742merce_s
mercy125916182merc__y
merely111312592mer_ely
merer75126232mer_er_
merger95016482merger_
mergers103813422mergers
merry104721492mer__ry
sorcery1237032sorcery
aerier64823163aerier_
amerce10310513amerce__
amerced1256523amerce_d
amerces1149853amerce_s
archery15478063_archery
artery9911453_artery
beanery1237563beanery
beery105220123be__ery
bergere1068913bergere
berry104521773ber__ry
berserk1334913berserk
brewery15376963brewery
briery114510773_briery
celery1139623ce_lery
coercer1138383coercer_
coercers1237653coercers
deanery1137613deanery
decern91310953de_cern
decry115514353de_c_ry
decury1277963de_cury
deicer94114413deicer_
deicers103612733deicers
derry94721373der__ry
descry1256183desc_ry
eatery95316353_eatery
eerier64320023eerier_
eery76129623_e__ery
embracery1893203embracery
emery104814333_e_mery
empery1348683_empery
every115215453_e_very
farcer115016083farcer_
farcers124713443farcers
fencer114613533fencer_
fencers123810623fencers
ferrety13287013ferrety
ferry116020803fer__ry
fiercely1643323fiercely
fiercer12356953fiercer_
forcer114917343forcer_
forcers124215713forcers
forgery14419303forgery
gerbera1034773gerbera
grocery13336763grocery
hellery13329213hellery
hennery1335303hennery
herder104516463herder_
herders113914123herders
hereby14468333her_eby
heresy125011233her_esy
heronry1346043heronry
herry114922473her__ry
jerker17369043jerker_
jerkers18287083jerkers
jerry155016183jer__ry
jersey1636333jerse_y
kerry124916093ker__ry
kersey1336793kerse_y
larceny1234853larceny
lechery15257643lechery
leery85919133le__ery
macer912126943m_acer_
macers105321273m_acers
marcel103714853marce_l
marcels113212373marcels
marcher143912973marcher_
marchers153710813marchers
marker124420393marker_
markers133516103markers
marrer83716673marrer_
marrers93414313marrers
marry104821693mar__ry
martyry1533373martyry
mastery124214323mastery
mattery123810713mattery
meager94515203meager_
meagerly1444003meagerly
meaner84617843meaner_
meaners94415243meaners
medley1298343medle_y
meeker12359983meeker_
meeter83616503meeter_
meeters94714543meeters
melder93915813melder_
melders103213913melders
melter83520113melter_
melters93918313melters
member12258853member_
members13258603members
memory1338803me_mory
menacer112610883menacer_
menacers12279313menacers
mender93520793mender_
menders103818803menders
merc87225623merc___
merceries13410043merceries
mercerise1356413mercerise
mercerize2246173mercerize
merch125417963merc__h
merches144013763merches
mercies113817563mercies
mercs96020453merc__s
mercuric1444403mercuric
merde84320123merde__
merdes94518603merde_s
mere67244443mer_e__
meres75143573mer_e_s
merest84725113mer_est
merge84523693merge__
merged104214953merge_d
mergee94018143merge_e
mergees104411233mergees
merges94122493merge_s
merle75824373merle__
merles85322763merle_s
mermen10813813merme_n
merrier92612303merrier_
merrily1238633merrily
meter75130323me_ter_
meters85625833me_ters
metier83517693metier_
metiers93312843metiers
mewler113510233mewler_
mewlers12288983mewlers
mincer104017363mincer_
mincers113714853mincers
mirier83918363mirier_
mirker123712693mirker_
misery114113543m_isery
mockery18376913mockery
monkery16317453monkery
mopery135210973m_opery
morceau1145573morceau
mortary12369043mortary
mothery153710513mothery
mummery13336663mummery
murder93613783murder_
murders103311363murders
murker123715243murker_
murrey114312263murre_y
murry105120233mur__ry
mystery15436523mystery
nursery10396023nursery
ornery938463_ornery
orrery936783_orrery
peccary1636283peccary
pedlery13297083pedlery
peery105719443pe__ery
peppery13286253peppery
percent113520603percent
percept133112523percept
percher143313423percher_
perchers153611523perchers
perjury19244253perjury
perry105222713per__ry
perter84422283perter_
pervert12315583pervert
piercer11337773piercer_
piercers12316723piercers
revery124014213re_very
sealery104011053sealery
secern81010223se_cern
secrecy1444743secrecy
serer55935513ser_er_
serger73819743serger_
sergers83815633sergers
serry84824123ser__ry
server94917713server_
servers103214833servers
smeltery13274963smeltery
spicery14499013spicery
surgery11319213surgery
terce75721843terce__
tercel83612993terce_l
tercels94110363tercels
terces83921413terce_s
tercet83624913terce_t
tercets93512443tercets
termer85717253termer_
termers95414503termers
ternary1038343ternary
terry84721873ter__ry
tersely1038113tersely
terser67317823terser_
tracery12399793tracery
turnery10357423turnery
veery115816253ve__ery
venery123710663ve_nery
verger104315703verger_
vergers114412633vergers
verier94620963verier_
verser94516963verser_
versers103813523versers

Search took 10 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.453394461.4
2DLD Change Limit1340272099.28014442.6
3Display Results2092090.0802612.5
 (SQL Overall)1786912099.81318209.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.