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

124 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
codified153740(None) 
codifier1447161codifier
codifies1439641codifies
modified1537271modified
acidified16104982acidified
citified1438252citified
coalified1546812coalified
codifiers1555342codifiers
coifed124113062co_if_ed
coiffed1635412co_iffed
cornified1546622cornified
edified12339712_edified
modifier1446702modifier
modifies1439162modifies
nidified1346762nidified
notified1238362notified
recodified1765532recodified
scorified1546192scorified
uncodified1743392uncodified
acetified1545893acetified
acidifier15124383acidifier
acidifies15126453acidifies
aerified121310133aerified
basified1437823basified
bodied103814583bod__ied
caddied123710563cad_died
calcified1746893calcified
carnified1547293carnified
casefied1445943casefied
cavitied14126813cavitied
certified1548413certified
chivied16368383c_hivied
citied94014143c__itied
citifies13310683citifies
cityfied1742703cityfied
clarified1546973clarified
coalfield1541823coalfield
coalifies1439113coalifies
codded114515303cod__ded
coddled123410573cod_dled
coded95433183cod___ed
coderived1644793coderived
codfish1637163cod_fish
codices12512583codi_ces
codicil1246813codici_l
codicils1346043codicils
codify1537163codif__y
codifying1944953codifying
coedited1237833coedi_ted
coffined1735993coffined
coffled16297363co_ffled
coiffe1447043co_iffe_
coiffes1546803co_iffes
coifing133213893co_ifing
coigned11418663co_igned
coiled95123943co_i_led
coined94523603co_i_ned
collied103316673co_llied
comfier1439163co_mfier
comities12317793comities
commodified2252383commodified
complied1539673complied
confide13310203co_nfide
confided1537453confided
confined14310403confined
conifer123212643conif_er
copied114618563co__pied
copurified1843173copurified
cornfed1337383cornf_ed
cornfield1542853cornfield
cornifies1439003cornifies
cosied94819883co__sied
cosigned1235723cosigned
covaried1448003covaried
cozied184112153co__zied
crucified1744683crucified
dandified1555553dandified
defied115016383__defied
deified123112413_deified
edifier11309263_edifier
edifies113012283_edifies
fortified1646503fortified
gasified1336533gasified
glorified1445003glorified
horrified16145063horrified
humified1745653humified
ignified1386213ignified
iodised9329243iodi_sed
iodized18969163iodi_zed
jollified2044303jollified
minified1439653minified
modifiers1584483modifiers
mollified1545653mollified
mortified1547383mortified
nazified2144993nazified
nidifies1238233nidifies
notifier1137423notifier
notifies11310423notifies
ossified1276433ossified
pacified1638363pacified
purified1438743purified
ramified1438043ramified
rarified1239053rarified
ratified12310503ratified
recodifies16106323recodifies
redefied1368223redefied
reedified1446503reedified
reified112913783_reified
remodified17115263remodified
salified12310363salified
scarified1547293scarified
scorifier1445413scorifier
scorifies1448023scorifies
solidified1544003solidified
torrified13125593torrified
typified1743923typified
uglified1345293uglified
unified112413573_unified
unmodified1742903unmodified
verified151510393verified
vilified1547243vilified
vinified1537543vinified
vivified1845893vivified
zombified2642843zombified

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.423422437.4
2DLD Change Limit1461621247.36019859.0
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.82922824.2
 
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.