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

96 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
vilified154724(None) 
vilifier1456691vilifier
vilifies1439591vilifies
vinified1537541vinified
vivified1845891vivified
citified1438252citified
minified1439652minified
nidified1346762nidified
salified12310362salified
uglified1345292uglified
verified151510402verified
vilifiers1544562vilifiers
vinifies1439872vinifies
vitrified1645982vitrified
vivifier1745172vivifier
vivifies1747022vivifies
acidified16104983acidified
aerified121310143aerified
airlifted1343193airlifted
alibied1038143_alibied
amplified17115373amplified
basified1437823basified
bikinied1543513bikinied
calcified1746893calcified
ciliated11510953ciliated
citifies13310683citifies
cityfied1742703cityfied
coalified1546813coalified
codified1537403codified
deified123112413_deified
dignified1545573dignified
dulcified1644463dulcified
edified12339713_edified
falsified1644983falsified
filiated12610083filiated
filicide1446363filicide
gasified1336533gasified
gillied95512313gil_lied
humified1745653humified
ignified1386213ignified
jellified2044813jellified
jollified2044303jollified
lifted104413523__lifted
lignified1445063lignified
lilied73913213__lilied
liquified2244283liquified
lithified1644463lithified
micrified17126803micrified
minifies13312903minifies
modified1537273modified
mollified1545653mollified
nazified2144993nazified
nidifies1238233nidifies
nigrified1445333nigrified
nitrified1346733nitrified
notified1238363notified
nullified1344943nullified
ossified1276433ossified
pacified1638363pacified
purified1438743purified
qualified2245843qualified
ramified1438043ramified
rarified1239053rarified
ratified12310503ratified
reified112913783_reified
revivified2043833revivified
salifies11314793salifies
signified1446043signified
silicide1147833silicide
silicified1643493silicified
simplified1853653simplified
sissified1345543sissified
typified1743923typified
uglifier1244503uglifier
uglifies1246383uglifies
unified112413573_unified
uplifted1454423uplifted
vanitied12138213vanitied
verbified18146023verbified
verifier14159203verifier
verifies141313483verifies
versified16147603versified
vilify1536773vilif__y
vilifying1944493vilifying
vilipend1442523vilipend
viricide1446423viricide
virilized2246233virilized
visioned1247013visioned
visited1168773visi_ted
vitiated12289223vitiated
vitrifies1547223vitrifies
vivific1843363vivifi_c
vivifiers1843673vivifiers
willied114611563wil_lied
zincified2444293zincified
zinkified2643163zinkified

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.486367677.0
2DLD Change Limit146162967.39019778.3
3Display Results96960.0462087.0
 (SQL Overall)178691967.92222556.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.