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

179 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
demerges1212950(None) 
demerge11168021demerge_
demerged13157601demerged
demerger12127371demerger
demergers13146401demergers
deterges101510091deterges
emerges101310881_emerges
remerges111110201remerges
demerits11310762demerits
demesnes1137082demesnes
demiurges1343862demiurges
deserves12109892deserves
deterge9118462deterge_
deterged11127922deterged
deterger10147592deterger
detergers11147182detergers
diverges13258312diverges
emerge91510462_emerge_
emerged11158212_emerged
emeries91620022_emeries
immerges1345392immerges
merges94122482__merges
reemerges1255172reemerges
remerge10148922remerge_
remerged12149172remerged
amerces1149853_amerces
asperges11318093asperges
auberges1146673auberges
bemires113212833bemir_es
beverages1595223beverages
celeries10316313celeries
damages11511273dam_ages
deaerates10313643deaerates
deaneries10310833deaneries
dearies83526273de_aries
decares102818533decar_es
deceases11410153deceases
deceives1437903deceives
decerned1237263decerned
decerns10119053decer_ns
decrees102513123de_crees
decries103319803de_cries
decuries11312223decuries
decurves1435863decurves
deers64930523de_er__s
defences1439633defences
defenses1237913defenses
deferred13106363deferred
deferrer12135593deferrer
deferrers13115153deferrers
defers105116943defer__s
deforces14248403deforces
degermed1335453degermed
degerms1135623deger_ms
degrees92810723de_grees
dekares122710873dekar_es
deleaves1248063deleaves
deletes83117933dele_tes
deluges9169263de_luges
demarches1745913demarches
demarked16187223demarked
demarks14339233demar_ks
demeaned1237283demeaned
demeans1039713deme_ans
demented12311273demented
dements103016623deme_nts
demerara1144853demerara
demeraras1243733demeraras
demergered1543173demergered
demerging1436643demerging
demerit10314993demer_it
demerited1339073demerited
demersal1145263demersal
demes86032693dem___es
demesne1035573demesne_
demetons1137623demetons
demies94825803dem__ies
demirep1236213demir_ep
demireps1343993demireps
demises103719563dem_ises
demiurge1243873demiurge_
demoses103815823dem_oses
demotes104717673dem_otes
demure9311533demur_e_
demurer1037873demur_er
demurest1137453demur_est
demurrages1442333demurrages
demurred1234933demurred
demurrer1144043demurrer
demurrers1243713demurrers
demurs939773demur__s
depermed1436453depermed
deperms1236603deper_ms
deranges1039973deranges
derries83124623de_rries
descries11311923descries
deserted101012203deserted
deserter91211603deserter
deserters10129983deserters
deserts82513053deser_ts
deserve11108703deserve_
deserved13108133deserved
deserver12118383deserver
deservers13107293deservers
desexes1537833dese_xes
desires81316133desir_es
detentes92712873detentes
detergent11129573detergent
detergents12116663detergents
deterred10137803deterred
deterrer9137013deterrer
deterrers10116593deterrers
deters74724683deter__s
dimerizes2167943dimerizes
dimerous1139323dimerous
dimers94321093dimer__s
dirges84915103d__irges
diverge12347643diverge_
diverged14256883diverged
doweries12411933doweries
dredges10379343d_redges
duperies11312813duperies
embrues1136473_embrues
emergent1149113_emergent
emergents1245973_emergents
emerods10137653_emerods
emersed10138513_emersed
emeses86114963_eme_ses
emeutes938013_emeutes
emigres1037673_emigres
emperies12314563_emperies
energies9310783_energies
epergnes1156713_epergnes
exergues1644123_exergues
immerge1244703immerge_
immerged1444023immerged
immerses1235953immerses
lemures938793lemur_es
leverages1365663leverages
marges94525713__marges
memories121214353memories
merces105720743__merces
merdes94518603__merdes
meres75143573__mer_es
merge84523683__merge_
merged104214943__merged
mergee94018133__mergee
mergees104411233__mergees
merger95016473__merger
mergers103813423__mergers
merles85322763__merles
meterages1248183meterages
nemeses948663neme_ses
peerages1189893pe_erages
peeries93623023pe_eries
premerger1444903premerger
reemerge1154793reemerge_
reemerged1354403reemerged
referees111310413referees
reforges12249333reforges
regorges10238413regorges
remedies11310553remedies
remiges103015473rem_iges
remorses10311993remorses
reneges82513593rene_ges
reserves111011983reserves
resurges9310123resurges
revenges1238983revenges
reveres103621343rever_es
reveries112518513reveries
reverses112513513reverses
rezeroes1737143rezeroes
sememes11109203seme_mes
serges74225963__serges
sewerages1345363sewerages
submerges1446283submerges
veeries102916893ve_eries
veneries112815033veneries
verges104320173__verges

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621797.20320291.8
3Display Results1791790.0802237.5
 (SQL Overall)1786911797.43924020.8
 
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.