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

236 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
purifies1331192(None) 
purified1438741purified
purifier1338561purifier
purifiers1435871purifiers
purities10316281purities
aerifies111313392aerifies
copurifies1754352copurifies
pacifies15311222pacifies
parities10522972parities
petrifies14310352petrifies
privies122414262p_rivies
purfles122511842pur_fles
purines94420762puri_nes
putrefies1444662putrefies
rarifies11311932rarifies
repurifies1546142repurifies
unifies102714712_unifies
verifies141313482verifies
aerified121310133aerified
auricles10138333auricles
basifies13310493basifies
brinies93317913_brinies
brutifies1445713brutifies
burdies104117563bur_dies
buries84633273bur__ies
burnies94017823bur_nies
carnifies1439893carnifies
certifies14310323certifies
citifies13310683citifies
clarifies1448633clarifies
codifies1439643codifies
copurified1843173copurified
cornifies1438993cornifies
crucifies1646123crucifies
curacies12311763curacies
curies84934023cur__ies
curites93919863curi_tes
curries93723163cur_ries
curtsies1038733curtsies
deifies113317453_deifies
dulcifies1545273dulcifies
durries83817353dur_ries
edifies113012283_edifies
eurokies1246313eurokies
ferities111416713ferities
fortifies1548683fortifies
furies95126373fur__ies
furmities1447523furmities
gasifies1238693gasifies
glorifies1346363glorifies
griffes14367923_griffes
gurries83515953gur_ries
horrifies15146383horrifies
humified1745653humified
hurdies114015663hur_dies
hurlies103315333hur_lies
hurries103919653hur_ries
ignifies1277563ignifies
impurities14136433impurities
juries134120633jur__ies
justifies1945793justifies
metrifies1439793metrifies
micrifies16118673micrifies
minifies13312893minifies
modifies1439163modifies
mortifies1439393mortifies
mummifies1543703mummifies
muriates10312083muriates
murices112612283muri_ces
murines93718223muri_nes
murphies1536453murphies
murries94118673mur_ries
mutinies10311503mutinies
nazifies2036063nazifies
nidifies1238233nidifies
nigrifies1346363nigrifies
nitrifies12107923nitrifies
notifies11310423notifies
nudities939683nudities
nullifies1245803nullifies
opacifies1645463opacifies
orifices1346483_orifices
ossifies1177563ossifies
pacified1638363pacified
pacifier1557503pacifier
pacifiers1645463pacifiers
paries84742513par__ies
parietes10714543parietes
parises94827183pari_ses
parishes13314753parishes
parodies11313693parodies
parries93925843par_ries
parties93230863par_ties
paucities1348503paucities
perfidies1546593perfidies
perigees1189493perigees
periques1937653periques
perishes13313753perishes
periwigs1444193periwigs
perries93226603per_ries
petrified1548333petrified
petrifier1447123petrifier
petrifiers1544673petrifiers
piracies12312643piracies
pirogies1139423pirogies
pities83828083p__ities
pixies154915513p__ixies
pleurisies1243173pleurisies
ploidies1138173ploidies
policies122415663policies
polities102722343polities
porgies103017003por_gies
porkies133416493por_kies
porkpies1636193porkpies
prairies10411453prairies
prefiles133113443p_refiles
prefires134313283p_refires
prefixes20389233p_refixes
premies113823063p_remies
prexies163415003p_rexies
prices104524543p_ri_ces
pricier113313113p_ricier
priciest122112903p_riciest
prides94324183p_ri_des
pries74339533p_r__ies
primes104225263p_ri_mes
primines123013703p_rimines
princes113015143p_rinces
priories10312453p_riories
prises84133173p_ri_ses
prisses94816713p_risses
prissies101712003p_rissies
privier122910453p_rivier
priviest132310313p_riviest
prizes173819813p_ri_zes
profiles133211233p_rofiles
profits122911243p_rofits
proxies163014933p_roxies
puffier1547973pu_ffier
puffiest1647313pu_ffiest
puffins15278913pu_ffins
puggries12166383puggries
puisnes937423pu_isnes
pulicides1446283pulicides
pumices1338273pumi_ces
pumicites1545623pumicites
punishes1338113punishes
punkies134216803pu_nkies
punties94520783pu_nties
puppies103212613pu_ppies
purees84721683pur__ees
purfle112511183pur_fle_
purfled13248723pur_fled
purfler12248733pur_fler
purflers13216963pur_flers
purges94421763pur__ges
purify14399153purif__y
purifying1835853purifying
purine85321893puri_ne_
purins83722653pur__ins
puris75332023pur__i_s
purisms114110833puri_sms
purists94014073puri_sts
puritans1037633puritans
purlieu938143pur_lieu
purlieus1034633pur_lieus
purlines103514053purlines
purlins93415423pur_lins
purloins1077033purloins
purples112712823pur_ples
purposes1237823purposes
purpures1276143purpures
purses84826373pur__ses
pursier94012753pur_sier
pursiest102812123pur_siest
pursues94111373pur_sues
pursuits1045043pursuits
purtier93214093pur_tier
purtiest102414113pur_tiest
purview1534233pur_view
purviews1642533pur_views
pussies93615693pu_ssies
pusslies1036173pusslies
putrefied1543673putrefied
putrefier1443123putrefier
putrefiers1542513putrefiers
putties94420023pu_tties
pyridines1546473pyridines
pyrites12812203pyri_tes
qualifies2147503qualifies
ramifies13310503ramifies
rarefies1138993rarefies
rarified1239053rarified
rarities8316333rarities
ratifies11313513ratifies
reifies104218283_reifies
repurified1645163repurified
reunifies1247583reunifies
rifles94217703__rifles
russifies1245443russifies
salifies11314793salifies
scarifies1439603scarifies
scorifies1448013scorifies
specifies1647573specifies
spurries102311323spur_ries
strifes104716583strif_es
sureties8316583sureties
surfier102613543sur_fier
surfiest112414423sur_fiest
surimis938843surimi_s
terrifies12139703terrifies
torrifies12137023torrifies
trifles103814823_trifles
tumefies1345773tumefies
turfier10249793tur_fier
turfiest112410123tur_fiest
typifies1644963typifies
uglifies1246383uglifies
unified112413563_unified
unifier102211863_unifier
unifiers11237173_unifiers
unities72520143_unities
uprises92012733upri_ses
uridines989513_uridines
urines64724123_uri_nes
verbifies17157123verbifies
verified151510393verified
verifier14159203verifier
verifiers15166063verifiers
verities111418043verities
versifies15159333versifies
vilifies1439593vilifies
vinifies1439873vinifies
vitrifies1547223vitrifies
vivifies1747023vivifies
yuppifies1942693yuppifies

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.1561145455.1
2DLD Change Limit1461622368.40317394.0
3Display Results2362360.0962458.3
 (SQL Overall)1786912368.65520646.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.