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

116 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
mortifies143939(None) 
fortifies1548691fortifies
mortified1547381mortified
mortifier1446921mortifier
mortifiers1544391mortifiers
certifies14310322certifies
cornifies1439002cornifies
fortified1646502fortified
fortifier1546252fortifier
fortifiers1644532fortifiers
horrifies15146392horrifies
metrifies1439802metrifies
modifies1439162mo_difies
mollifies1447552mollifies
mortices12711562morti_ces
mortises10713612morti_ses
mystifies1745882mystifies
notifies11310422no_tifies
torrifies12137032torrifies
acetifies1447133acetifies
aerifies111313393aer_ifies
amortises1178823amorti_ses
amortizes2087283amorti_zes
artifices1446473_artifices
beatifies1459283beatifies
brutifies1445713brutifies
carnifies1439893carnifies
certified1548413certified
certifier1447353certifier
certifiers1545143certifiers
citifies13310683_citifies
coalifies1439113coalifies
codifies1439643co_difies
cornified1546623cornified
cortices12615013corti_ces
forties104323863fort__ies
fortuities1346323fortuities
glorifies1346363glor_ifies
gratifies1347993gratifies
horrified16145063horrified
jollifies1945553jollifies
justifies1945793justifies
magnifies1547283magnifies
martinis103311613martini_s
martyries1446563martyries
metrified1547853metrified
micrifies16118673micrifies
minifies13312903m_inifies
modified1537273mo_dified
modifier1446703mo_difier
modifiers1584483mo_difiers
mollified1545653mollified
mollifier1445163mollifier
mollifiers1543993mollifiers
monthlies1446513monthlies
moraines10314363morai_nes
moralities121111923moralities
morbific1743183morbifi_c
moronities1249063moronities
morosities1248413morosities
morrises10711073morri_ses
mortalities1348423mortalities
mortgages1344023mortgages
mortice11711493morti_ce_
morticed1377163morti_ced
mortician1346993mortician
morticians1445703morticians
morticing1448013morticing
mortify1536223mortif__y
mortifying1944923mortifying
mortise9713533morti_se_
mortised1178743morti_sed
mortiser1078473morti_ser
mortisers1186163mortisers
mortising1238693mortising
mortmains1344493mortmains
mortuaries1245373mortuaries
motific1446323mo_tifi_c
motifs1139673mo_tif__s
motiles93317433mo_ti_les
motives123611893mo_ti_ves
mummifies1543713mummifies
mutinies10311503m_utinies
mystified1845083mystified
mystifier1744363mystifier
mystifiers1843113mystifiers
nitrifies12107923nitrifies
notified1238363no_tified
notifier1137423no_tifier
notifiers1245023no_tifiers
orifices1346483_or_ifices
ossifies1177563_ossifies
petrifies14310363petrifies
pontifices1744183pontifices
porticoes1348253porticoes
portieres1138213portieres
purifies13311923pur_ifies
rarifies11311933rar_ifies
ratifies11313513_ratifies
rectifies14310813rectifies
refortifies1753773refortifies
reifies104218283__reifies
scorifies1448023scor_ifies
sorties74126403sort__ies
stratifies1346743stratifies
terrifies12139723terrifies
testifies12139263testifies
torrefies12114753torrefies
torrified13125593torrified
verbifies17157133verbifies
verifies141313483ver_ifies
versifies15159333versifies
vitrifies1547223vitrifies
vortices1369123vorti_ces
worthies14310283wort_hies
zombifies2543213zombifies

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411166.53322752.3
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.01525472.7
 
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.