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

158 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
demerit1031499(None) 
demerits11310761demerits
deceit93018212dece_it
dement93825142deme_nt
demerge11168022demerge
demerited1339072demerited
demit84832302dem__it
desert72725492deser_t
dimeric12310012dimeric
emerita938712_emerita
emeriti949432_emeriti
merit7339182__merit
temerity1346902temerity
benefit1248073benefit
celerity1347643celerity
cement103321663ceme_nt
dammit11311133dam_mit
deaerate9314173deaerate
dearest83618673dearest
dearie73319813de_arie
debit85727853d__ebit
debris93311493de_bris
deceits102810883dece_its
decent94023703dece_nt
decern91310953decer_n
decerns10119053decerns
decrepit1345873decrepit
deer56739023de_er__
deers64930523de_er_s
deet57356583de_e__t
defeat103817163defe_at
defect124816173defe_ct
defer94619753defer__
deferent122712873deferent
defers105116943defer_s
deficit1339673deficit
degerm1037893deger_m
degerms1135623degerms
dehort104618103dehor_t
deject164512843deje_ct
delimit10311733delimit
deliria868303deliria
demark134211023demar_k
demarks14339233demarks
demast9517063dem_ast
deme76536283deme___
demean9510563deme_an
demeans1039713demeans
dementia1157823dementia
dements103016623dements
demerara1144853demerara
demerged13157603demerged
demerger12127373demerger
demerges12129503demerges
demerging1436643demerging
demeriting1448683demeriting
demersal1145263demersal
demes86032693deme__s
demesne1035573demesne
demeton1037683demeton
demic105119193dem__ic
demirep1236213demirep
demits94918073dem__its
democrat1347943democrat
demonic12311223demonic
demonist11413463demonist
demotic12412343demotic
demotist11311843demotist
demount1049743demount
demur8311163demur__
demure9311533demur_e
demurer1037873demurer
demurest1137453demurest
demurs939773demur_s
denari710917353denari_
denarii8389123denarii
dendrite1048783dendrite
deorbit1048173deorbit
depart94720563depar_t
deperm1139363deper_m
deperms1236603deperms
deport94922393depor_t
deposit10313003deposit
derat65044083d__erat
derelict11138483derelict
derris73615273de_rris
desertic1147743desertic
deserts82513053deserts
deserve11108703deserve
dessert82916453desser_t
detect94217403dete_ct
detent73624483dete_nt
deter65028043deter__
deterge9118463deterge
deters74724683deter_s
detest74122843dete_st
deuteric1146343deuteric
devein1039143deve_in
devest104418703deve_st
dexterity2044343dexterity
dextrin1587543dextrin
dimer85625603dimer__
dimerism1347213dimerism
dimerize2048113dimerize
dimers94321093dimer_s
dimetric1348653dimetric
dimwit1237953dim_wit
dineric10310973dineric
disherit12412523disherit
divert103922813diver_t
dolerite9611773dolerite
eerie55228533_e_erie
elegit71212893_elegit
emerge91510463_emerge
emeries91620023_emeries
emeritae1046353_emeritae
emeritas1046433_emeritas
emeritus1045173_emeritus
emerod9139213_emerod
emeroid101511183_emeroid
emery104814333_emer_y
emesis84712623_emesis
emetic10614453_emetic
emetin8613463_emetin
emit65438423_em__it
esprit8312843_esprit
evert84929513_ever_t
exert124624143_exer_t
feterita1166463feterita
generic101310753generic
gomeril1047383gomeril
homeric14312213homeric
humeri1138523humeri_
inherit10312973inherit
legerity1245713legerity
leveret103014003leveret
merits8320873__merits
mesmeric1445813mesmeric
mesmerist1346593mesmerist
nemesis937373nemesis
numeric1158193numeric
peerie83617893pe_erie
peewit111110903pe_ewit
preterit10315843preterit
reedit7617223re_edit
reemit8717223re_emit
remeet86325473reme_et
remelt85123123reme_lt
remerge10148923remerge
remet74843723reme__t
remit75737223rem__it
remorid10311863remorid
reverie103615163reverie
revert93529113rever_t
sememic1336503sememic
semifit1249973semifit
severity1446973severity
territ63421373te_rrit

Search took 9 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.1401276364.3
2DLD Change Limit1340271587.87317023.6
3Display Results1581580.250632.0
 (SQL Overall)1786911588.26321625.4
 
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.