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

189 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
ratified1231050(None) 
gratified1446251gratified
ramified1438041ramified
rarified1239051rarified
ratifier1139671ratifier
ratifies11313511ratifies
basified1437822basified
beatified1577862beatified
brutified1544772brutified
citified1438252citified
gasified1336532gasified
gratifier1345822gratifier
gratifies1347992gratifies
nazified2144992nazified
notified1238362notified
pacified1638362pacified
ramifies13310502ramifies
rarefied1245912rarefied
rarifies11311932rarifies
raticide1148942raticide
ratifiers1236452ratifiers
rationed9410092rationed
rectified1539242rectified
reified112913782r_eified
salified12310362salified
satisfied1343872satisfied
stratified1445172stratified
acetified1545893acetified
aerified121310133aerified
alibied1038143_alibied
argufied1342323argufied
articled1137063articled
artifice1346403artifice
artificer1444023artificer
artifices1446473artifices
basifier1337313basifier
basifies13310493basifies
basifixed2242603basifixed
batiked1435963bati_ked
beatifies1459283beatifies
beautified1654223beautified
brutifies1445713brutifies
calcified1746893calcified
carnified1547293carnified
casefied1445943casefied
cavitied14126813cavitied
certified1548413certified
citifies13310683citifies
cityfied1742703cityfied
clarified1546973clarified
coalified1546813coalified
codified1537403codified
crucified1744683crucified
daisied93410013da_isied
damnified1644883damnified
dandified1555553dandified
deified123112413_deified
edified12339713_edified
falsified1644983falsified
fancified1865793fancified
fatigued1342943fatigued
fortified1646503fortified
fructified1942753fructified
gasifier1236273gasifier
gasifies1238693gasifies
gratifiers1443863gratifiers
gratineed11334473gratineed
humified1745653humified
ignified1386213ignified
justified2045043justified
latinized1988533latinized
lithified1644463lithified
magnified1645763magnified
metrified1547853metrified
minified1439653minified
modified1537273modified
mortified1547383mortified
mutinied1148163mutinied
mystified1845083mystified
nancified1565543nancified
nazifies2036063nazifies
nidified1346763nidified
nitrified1346723nitrified
notifier1137423notifier
notifies11310423notifies
opacified1744393opacified
ossified1276433ossified
pacifier1557503pacifier
pacifies15311223pacifies
patinaed11407833patinaed
patined105114783pati_ned
patinized2178823patinized
petrified1548333petrified
prettified1644943prettified
purified1438743purified
qualified2245843qualified
quantified2344263quantified
radiated102512593radiated
radioed939673radi_oed
raffled14429083ra_ffled
rafted104714703ra__fted
raided85017703ra_i_ded
railed74727543ra_i_led
rained75024603ra_i_ned
rainier71614263ra_inier
raised76120333ra_i_sed
rallied83514083ra_llied
ramilie9310283ramilie_
ramilies10311833ramilies
rapiered1136053rapiered
rarefier1135353rarefier
rarefies1138993rarefies
rarities8316333rarities
ratafee1047523rataf_ee
ratafees1144143ratafees
ratafia1045773ratafi_a
ratafias1145323ratafias
ratanies8312923ratanies
rated65441383rat___ed
ratfink1434943rat_fink
ratfish1338773rat_fish
raticides1248693raticides
ratify122610043ratif__y
ratifying1656823ratifying
ratine65131823rati_ne_
ratines75328583rati_nes
ratite65022423rati_te_
ratites74920683rati_tes
ratooned977103ratooned
rattailed1084213rattailed
ratted74923343rat__ted
rattened9218623rattened
rattier74015593rat_tier
rattled84012953rat_tled
ravined115411823ravi_ned
ravished1555713ravished
rectifier1457733rectifier
rectifies14310813rectifies
redefied1368223redefied
reedified1446503reedified
reifier103414523r_eifier
reifies104218283r_eifies
renotified1455813renotified
repacified1844893repacified
resifted12310153resifted
retied75924983ret__ied
retiled84420513reti_led
retimed104714653reti_med
retinted94414363retinted
retinued95210823retinued
retired84620143reti_red
retitled9339553retitled
retried84419153ret_ried
reunified1346593reunified
riffed133811563r__iffed
rifled104115003r__ifled
rifted104115313r__ifted
rotifer1036993rotif_er
russified1344733russified
salifies11314793salifies
sanctified1644293sanctified
satiated9311603satiated
satirised1046553satirised
satirized1957893satirized
satisficed1651993satisficed
satisfier1243733satisfier
satisfies1245323satisfies
scarified1547293scarified
stiffed14359583_stiffed
stifled113511093_stifled
stimied10310623_stimied
stratifies1346743stratifies
tackified1944713tackified
tariffed1533723tariffed
testified1397843testified
tidied83613273__tidied
tiffed13368393__tiffed
typified1743923typified
uglified1345293uglified
unified112413573_unified
untidied1038903untidied
vanitied12138213vanitied
vaticide1446863vaticide
verified151510393verified
vilified1547243vilified
vinified1537543vinified
vitrified1645983vitrified
vivified1845893vivified
waifed134011033wa_if_ed

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 Limit1461621897.18620339.8
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.68923239.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.