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

166 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
rarified123905(None) 
ramified1438041ramified
rarefied1245911rarefied
rarifies11311931rarifies
ratified12310501ratified
aerified121310132aerified
basified1437822basified
carnified1547292carnified
clarified1546972clarified
gasified1336532gasified
gratified1446252gratified
nazified2144992nazified
pacified1638362pacified
purified1438742purified
ramifies13310502ramifies
rarefier1135352rarefier
rarefies1138992rarefies
rarities8316332rarities
ratifier1139672ratifier
ratifies11313512ratifies
reified112913782r_eified
salified12310362salified
scarified1547292scarified
tariffed1533722tariffed
verified151510392verified
aerifies111313393aerifies
airfield1243143_airfield
alibied1038143_alibied
argufied1342323argufied
ariled75620323_ari_led
arrived11127353arri_ved
barfed125416383bar_f_ed
basifier1337313basifier
basifies13310493basifies
basifixed2242603basifixed
beatified1577863beatified
brutified1544773brutified
calcified1746893calcified
caried94528693car__ied
carnifies1439893carnifies
carried103717153car_ried
casefied1445943casefied
cavitied14126813cavitied
certified1548413certified
citified1438253citified
clarifier1446123clarifier
clarifies1448633clarifies
coalified1546813coalified
codified1537403codified
cornified1546623cornified
crucified1744683crucified
daisied93410013da_isied
damnified1644883damnified
dandified1555553dandified
deified123112413_deified
drifted12367953_drifted
edified12339713_edified
falsified1644983falsified
fancified1865793fancified
fortified1646503fortified
gasifier1236273gasifier
gasifies1238693gasifies
glorified1445003glorified
gratifier1345823gratifier
gratifies1347993gratifies
grifted12379583_grifted
harried113815533har_ried
horrified16145063horrified
humified1745653humified
ignified1386213ignified
lariated91212063lariated
magnified1645763magnified
married104715303mar_ried
metrified1547853metrified
micrified17126793micrified
minified1439653minified
modified1537273modified
mortified1547383mortified
nancified1565543nancified
nazifies2036063nazifies
nidified1346763nidified
nigrified1445323nigrified
nitrified1346723nitrified
notified1238363notified
opacified1744393opacified
ossified1276433ossified
pacifier1557503pacifier
pacifies15311223pacifies
parities10522973parities
parodied1238333parodied
parried103615723par_ried
parslied1137823parslied
partied103516553par_tied
petrified1548333petrified
purifier1338573purifier
purifies13311923purifies
qualified2245843qualified
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
rared65738323rar___ed
rarefiers1244023rarefiers
rarify123210063rarif__y
rarifying1646313rarifying
raticide1148943raticide
ratifiers1236453ratifiers
rationed9410093rationed
ravined115411823ravi_ned
ravished1555713ravished
rectified1539243rectified
redefied1368223redefied
reedified1446503reedified
reifier103414523r_eifier
reifies104218283r_eifies
repacified1844893repacified
repurified1645163repurified
rerigged1136243rerigged
resifted12310153resifted
reunified1346593reunified
reverified1745123reverified
riffed133811563__riffed
rifled104115003__rifled
rifted104115313__rifted
russified1344733russified
sacrificed18133373sacrificed
salifies11314793salifies
satisfied1343873satisfied
scarifier1446653scarifier
scarifies1439603scarifies
scorified1546193scorified
serifed11811463serif_ed
seriffed1594973seriffed
stratified1445173stratified
tackified1944713tackified
tarried83914133tar_ried
terrified13147573terrified
torrified13125593torrified
trifid1039063_trifi_d
trifled113711963_trifled
typified1743923typified
uglified1345293uglified
unified112413573_unified
unrifled1237423unrifled
vanitied12138213vanitied
variated121211393variated
varied104817863var__ied
varisized2244493varisized
verbified18146013verbified
verifier14159203verifier
verifies141313483verifies
versified16147593versified
vilified1547243vilified
vinified1537543vinified
vitrified1645983vitrified
vivified1845893vivified
waifed134011033wa_if_ed

Search took 9 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.406440125.6
2DLD Change Limit1461621667.78318779.6
3Display Results1661660.0602766.7
 (SQL Overall)1786911668.24921662.1
 
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.