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

112 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
purifiers143587(None) 
purifier1338571purifier_
purifies13311921purifie_s
pacifiers1645462pacifiers
petrifiers1544672petrifiers
purflers13216962pur_flers
purified1438742purifie_d
purities10316282puritie_s
putrefiers1542512putrefiers
unifiers11237172_unifiers
verifiers15166062verifiers
aerifies111313393aerifie_s
basifiers1445203basifiers
buriers94017193bur__iers
certifiers1545143certifiers
clarifiers1544013clarifiers
codifiers1555343codifiers
copurifies1754363copurifie_s
crucifiers1743073crucifiers
curriers103410753cur_riers
deifiers12348993_deifiers
drifters12417913_drifters
edifiers12336673_edifiers
fortifiers1644533fortifiers
furriers11369493fur_riers
fusiliers1243713fusiliers
gasifiers1344523gasifiers
glorifiers1442593glorifiers
grifters12389233_grifters
hurriers11358893hur_riers
justifiers2043083justifiers
lucifers1334163lucif_ers
modifiers1584483modifiers
mortifiers1544393mortifiers
nitrifiers1343923nitrifiers
notifiers1245023notifiers
nullifiers1343153nullifiers
opacifiers1742513opacifiers
ossifiers1274883ossifiers
pacifier1557503pacifier_
pacifies15311223pacifie_s
parities10522973paritie_s
parriers103612903par_riers
partiers103514243par_tiers
peripters1368123peripters
petrifier1447123petrifier_
petrifies14310363petrifie_s
pitiers93812653p__itiers
prefers123713333p_ref_ers
prefires134313283p_refires
premiers122911653p_remiers
pricers113915063p_ri_cers
pricier113313113p_ricier_
prickers163710673p_rickers
priers84521193p_r__iers
primers114215673p_ri_mers
prinkers143010383p_rinkers
printers103214903p_rinters
privier122910453p_rivier_
privies122414263p_rivie_s
prizers183911843p_ri_zers
proffers16126593p_roffers
profilers14236293p_rofilers
profiters14228313p_rofiters
puffers15349203pu__ffers
puffier1547973pu_ffier_
pumicers1434353pumi_cers
punishers1434973punishers
purfler12248733pur_fler_
purfles122511843pur_fle_s
purgers104714003pur__gers
purines94420763puri_ne_s
purlieus1034633pur_lieus
purloiners1242813purloiners
pursers93916093pur__sers
pursier94012753pur_sier_
pursuers10376523pur_suers
purtier93214093pur_tier_
purviews1642533pur_views
putrefier1443123putrefier_
putrefies1444663putrefie_s
puttiers10288013pu_ttiers
qualifiers2243333qualifiers
rarefiers1244023rarefiers
rarifies11311933rarifie_s
ratifiers1236453ratifiers
reifiers11309843_reifiers
repurifies1546143repurifie_s
ribiers9319753__ribiers
riflers103512193__riflers
scarifiers1544103scarifiers
scorifiers1543603scorifiers
specifiers1743803specifiers
spurriers11245063spur_riers
surfers103614133sur_f_ers
surfier102613543sur_fier_
terrifiers13144573terrifiers
thurifers1542913thurif_ers
triflers113110213_triflers
turfier10249793tur_fier_
typifiers1742303typifiers
uglifiers1343093uglifiers
unifier102211863_unifier_
unifies102714713_unifie_s
uplifters1463283uplifters
uprisers10206773upri_sers
uprivers13215563upri_vers
verifier14159203verifier_
verifies141313483verifie_s
versifiers16154143versifiers
vilifiers1544563vilifiers
vivifiers1843673vivifiers

Search took 10 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411129.31315960.6
3Display Results1121120.0462434.8
 (SQL Overall)1786911129.77918272.9
 
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.