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 “carnified” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
carnified154729(None) 
carnifies1439891carnifies
cornified1546621cornified
calcified1746892calcified
certified1548412certified
clarified1546972clar_ified
cornifies1439002cornifies
damnified1644882damnified
magnified1645762magnified
rarified1239052rar_ified
scarified1547292scar_ified
acetified1545893acetified
acidified16104983acidified
aerified121310133_aerified
argufied1342323_argufied
basified1437823ba_sified
calcifies1638923calcifies
candied113816023ca_n_died
canfield1444333ca_n_field
canities101519263ca_nities
canopied1336343ca_nopied
cardioid1247443cardioi_d
caried94528693car___ied
carinated123414263carinated
carnie84421093carn__ie_
carnies94123963carn__ies
carnify1555883carnif__y
carnifying1945043carnifying
carnitine1178573carnitine
carnitines1277813carnitines
carried103717153car__ried
casefied1445943ca_sefied
cavitied14126813ca_vitied
certifier1447353certifier
certifies14310323certifies
citified1438253c_itified
clarifier1446123clar_ifier
clarifies1448633clar_ifies
classified1644283classified
coalified1546813coalified
codified1537403c_odified
cornfed1337383corn_f_ed
cornfield1542853corn_field
corniced1368593corni_ced
crannied1137893cran_nied
crucified1744683crucified
damnifies1545543damnifies
dandified1555553dandified
dignified1545573dignified
falsified1644983falsified
fancified1865793fancified
fortified1646503fortified
garnished14196143garnished
gasified1336533ga_sified
gratified1446253gratified
horrified16145063horrified
ignified1386213_ignified
lignified1445063lignified
magnifier1545273magnifier
magnifies1547283magnifies
minified1439653_minified
mortified1547383mortified
nancified1565543nancified
nazified2144993na_zified
pacified1638363pa_cified
purified1438743pur_ified
ramified1438043ra_mified
rarefied1245913rar_efied
rarifies11311933rar_ifies
ratified12310503ra_tified
reified112913783__reified
reunified1346593reunified
salified12310363sa_lified
saponified1643493saponified
scarifier1446653scar_ifier
scarifies1439603scar_ifies
scorified1546193scor_ified
signified1446043signified
tackified1944713tackified
tariffed1533723tar_iffed
tarnished13196063tarnished
terrified13147573terrified
torrified13125593torrified
unified112413573__unified
vanitied12138213va_nitied
varnished16195603varnished
verbified18146013verbified
verified151510393ver_ified
versified16147593versified
vinified1537543_vinified

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 Limit148641907.03321134.8
3Display Results90900.0461956.5
 (SQL Overall)178691907.51523777.9
 
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.