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 “vilifier” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
vilifier145669(None) 
vilified1547241vilified
vilifiers1544561vilifiers
vilifies1439591vilifies
vivifier1745171vivifier
uglifier1244502uglifier
verifier14159202verifier
vinified1537542vinified
vinifies1439872vinifies
vivified1845892vivified
vivifiers1843672vivifiers
vivifies1747022vivifies
acidifier15124383acidifier
amplifier16104703amplifier
basifier1337313basifier
bilgier10358533bil_gier
citified1438253citified
citifies13310683citifies
cliffier1633913cliffier
codifier1447163codifier
deifier113013123_deifier
edifier11309263_edifier
falsifier1544433falsifier
filister1137403filister
filmier1237503fil_mier
filthier1434073filthier
gasifier1236273gasifier
gulfier1137793gul_fier
hillier103413963hil_lier
iffier1236763_i_ffier
lifer85822153__lif_er
lifter93814813__lifter
limier83518723__limier
linier64423793__linier
livier97514593__livier
midlifer14215793midlif_er
miffier1537023mi_ffier
milkier133411163mil_kier
millier93716703mil_lier
miltier93214963mil_tier
minified1439653minified
minifies13312903minifies
modifier1446703modifier
mollifier1445163mollifier
nidified1346763nidified
nidifies1238233nidifies
nitrifier1245963nitrifier
notifier1137423notifier
nullifier1244333nullifier
oilier64417233oil__ier
ossifier111196273ossifier
pacifier1557503pacifier
pilfer1139163pil_f_er
purifier1338573purifier
qualifier2145123qualifier
ratifier1139673ratifier
reifier103414523_reifier
salified12310363salified
salifies11314793salifies
signifier1345713signifier
silkier114411643sil_kier
sillier74017593sil_lier
siltier73413863sil_tier
simplifier1753103simplifier
slimier93212013_slimier
typifier1643403typifier
uglified1345293uglified
uglifiers1343093uglifiers
uglifies1246383uglifies
unifier102211863_unifier
uplifter1363903uplifter
veinier10269583v_einier
veliger1137313veli_ger
verified151510403verified
verifiers15166063verifiers
verifies141313483verifies
versifier15156533versifier
viewier1334983vi_ewier
viler86324163vil___er
vilify1536773vilif__y
vilifying1944493vilifying
villager12267513villager
vinier93716743v__inier
vinifera1443453vinif_era
visiter1038863visi_ter
vitrified1645983vitrified
vitrifies1547223vitrifies
vivider14265623vivi_der
vivific1843363vivifi_c
vizier184311023v__izier
wildfire1542803wildfire
wilier93217073wil__ier

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 Filter1786911461620.420425454.8
2DLD Change Limit146162928.70316794.4
3Display Results92920.0332787.9
 (SQL Overall)178691929.15619516.3
 
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.