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

111 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
notified123836(None) 
notifier1137421notifier
notifies11310421notifies
citified1438252citified
codified1537402codified
fortified1646502fortified
modified1537272modified
mortified1547382mortified
nazified2144992nazified
nidified1346762nidified
nitrified1346722nitrified
noticed1037862noti_ced
notifiers1245022notifiers
ratified12310502ratified
renotified1455812renotified
acetified1545893acetified
aerified121310133aerified
basified1437823basified
beatified1577863beatified
brutified1544773brutified
certified1548413certified
citifies13310683citifies
cityfied1742703cityfied
coalified1546813coalified
codifier1447163codifier
codifies1439643codifies
coifed124113063co_if_ed
coiffed1635413co_iffed
cornified1546623cornified
deified123112413_deified
edified12339713_edified
fortifier1546253fortifier
fortifies1548693fortifies
gasified1336533gasified
glorified1445003glorified
gratified1446253gratified
horrified16145063horrified
humified1745653humified
ignified1386213ignified
jollified2044303jollified
justified2045043justified
lithified1644463lithified
metrified1547853metrified
minified1439653minified
modifier1446703modifier
modifies1439163modifies
mollified1545653mollified
mortifier1446923mortifier
mortifies1439393mortifies
motific1446323motifi_c
motioned1137453motioned
motived13357763moti_ved
mutinied1148163mutinied
mystified1845083mystified
nancified1565543nancified
nazifies2036063nazifies
nidifies1238233nidifies
nigrified1445323nigrified
nitrifier1245963nitrifier
nitrifies12107923nitrifies
noised75416233no_i_sed
noisier759453no_isier
notaries8314933notaries
notarized1947153notarized
notated82713663not_ated
notched134210303not_ched
noted65123843not___ed
notice8313443noti_ce_
noticer937273noti_cer
notices9312283noti_ces
noticing1139453noticing
notify1236943notif__y
notifying1645623notifying
nullified1344943nullified
ossified1276433ossified
pacified1638363pacified
petrified1548333petrified
prenotified1753983prenotified
purified1438743purified
ramified1438043ramified
rarified1239053rarified
ratifier1139673ratifier
ratifies11313513ratifies
rectified1539243rectified
reified112913783_reified
renotifies1356893renotifies
rotifer1036993rotif_er
salified12310363salified
sanctified1644293sanctified
satisfied1343873satisfied
scorified1546193scorified
stiffed14359583_stiffed
stifled113511093_stifled
stimied10310623_stimied
testified1397843testified
tidied83613273__tidied
tiffed13368393__tiffed
torrified13125593torrified
typified1743923typified
uglified1345293uglified
uncodified1743393uncodified
unfortified1852913unfortified
unified112413573_unified
unmodified1742903unmodified
untidied1038903untidied
verified151510393verified
vilified1547243vilified
vinified1537543vinified
vitrified1645983vitrified
vivified1845893vivified
zombified2642843zombified

Search took 7 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.420425454.8
2DLD Change Limit1461621116.36022981.4
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.82626178.0
 
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.