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

105 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
modified153727(None) 
codified1537401codified
modifier1446701modifier
modifies1439161modifies
codifier1447162codifier
codifies1439642codifies
edified12339712_edified
minified1439652minified
modifiers1584482modifiers
mollified1545652mollified
mortified1547382mortified
nidified1346762nidified
notified1238362notified
remodified17115262remodified
unmodified1742902unmodified
acidified16104983acidified
aerified121310143aerified
ammonified1892993ammonified
amplified17115373amplified
basified1437823basified
bodied103814583bod__ied
citified1438253citified
coalified1546813coalified
codifiers1555343codifiers
coifed124113063co_if_ed
coiffed1635413co_iffed
commodified2252383commodified
cornified1546623cornified
dandified1555553dandified
defied115016383__defied
deified123112413_deified
edifier11309263_edifier
edifies113012283_edifies
fortified1646503fortified
gasified1336533gasified
glorified1445003glorified
horrified16145063horrified
humidified2052753humidified
humified1745653humified
ignified1386213ignified
iodised9329243iodi_sed
iodized18969163iodi_zed
jollified2044303jollified
magnified1645763magnified
mediated123011873mediated
medicide1447713medicide
medicined1545113medicined
metrified1547863metrified
micrified17126803micrified
midfield15203843mid_field
midwifed18233933midwif_ed
miffed15398713m__iffed
minifies13312903minifies
mobilised1445453mobilised
mobilized2346753mobilized
modeled1139463mod_eled
modelled1236433modelled
modemed1336723mod_emed
modify1537173modif__y
modifying1944663modifying
modiste1039283modiste_
modistes1138643modistes
moiled94318863mo_i_led
mollifier1445163mollifier
mollifies1447553mollifies
monied94319463mo__nied
monished1438133monished
mortifier1446923mortifier
mortifies1439393mortifies
motific1446323motifi_c
motioned1137453motioned
motived13357763moti_ved
muddied12339213mud_died
mummified1643253mummified
mutinied1148163mutinied
mystified1845083mystified
nazified2144993nazified
nidifies1238233nidifies
notifier1137423notifier
notifies11310423notifies
ossified1276433ossified
pacified1638363pacified
premodified20113583premodified
purified1438743purified
ramified1438043ramified
rarified1239053rarified
ratified12310503ratified
recodified1765543recodified
redefied1368223redefied
reedified1446503reedified
reified112913783_reified
remodifies16116023remodifies
salified12310363salified
scorified1546203scorified
solidified1544003solidified
torrified13125593torrified
typified1743923typified
uglified1345293uglified
uncodified1743393uncodified
unified112413573_unified
verified151510403verified
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.436409841.7
2DLD Change Limit1461621056.76621602.4
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.24824653.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.