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

241 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
vilify153677(None) 
vinify1536921vinify
vivify1834701vivify
citify1437442citify
minify1439252minify
nidify1336762nidify
oilily93111722oilily
salify12311372salify
uglify1333912uglify
verify153110162verify
vilely1239442vilely
vitrify1645002vitrify
wilily123310762wilily
ability12311443ability
acidify1645243acidify
aerify122810113aerify
agility1148653agility
ailing74331013ailing
airily93014823airily
airlift1048583airlift
alif76242143_alif_
alifs86121263_alifs
amplify1744083amplify
anility10312723anility
avidity1436483avidity
bailiff1546073bailiff
basify1437513basify
biffy164711133bi_ffy
bilby124912353bil_by
bilgy114713713bil_gy
biliary1238213biliary
billy105525363bil_ly
blimy125212823_blimy
calcify1735873calcify
calif104929103calif_
califs114915893califs
cilia73016763cili_a
ciliary1247923ciliary
cilice103213353cilice
cilium104311373cilium
civility1646123civility
cliff135917133_cliff
cliffy17435243cliffy
clift106422193_clift
coalify1536683coalify
codify1537163codify
deify124112763_deify
dicliny1337673dicliny
dignify1543893dignify
dilly94923783dil_ly
dimity12310473dimity
dulcify1643023dulcify
edify12308563_edify
evilly1236593evil_ly
falsify1643613falsify
filial93013253filial
filing103823763filing
filly114424903fil_ly
filmily1535733filmily
filmy136114043fil_my
filthy15356423filthy
fixity19427803fixity
gasify1336333gasify
gilly94321633gil_ly
gliff124915663_gliff
gulfy124612003gul_fy
hili75626633hili__
hilly114422163hil_ly
holily123612953holily
icily101211693_icily
iffy135312283_i_ffy
ignify1334513ignify
ilia46026823_ili_a
iliac75013493_iliac
iliad64613463_iliad
ilial55317843_ilial
ilium74614183_ilium
illy76925333_il_ly
jellify2054543jellify
jiffy21458313ji_ffy
jiminy1836273jiminy
jollify2044263jollify
kalif125021363kalif_
kalifs134410983kalifs
kilim11711893kili_m
kilims1277903kilims
kilty125213893kil_ty
life75433733__life
lift76942723__lift
lignify1443793lignify
lilied73913213lilied
lilies63021413lilies
lily76730183__lily
limy95727713__limy
liny78141323__liny
liquify2244033liquify
lithify1644763lithify
micrify1744693micrify
midlife13248303midlife
miffy163910203mi_ffy
milady1236613milady
mildly12318243mildly
milia72719573mili_a
miliary1249463miliary
milieu8314113milieu
milium104712683milium
milkily16216553milkily
milky144014443mil_ky
milty104720073mil_ty
modify1537173modify
mollify1555503mollify
nazify2134233nazify
nigrify1444133nigrify
nitrify1335793nitrify
notify1236943notify
nullify1334713nullify
oilier64417233oilier
oiling74925313oiling
oilway1235743oilway
oily77932253oil__y
ossify1244973ossify
ovality1377593ovality
pacify1667473pacify
pilaf103923483pilaf_
pilaff143910363pilaff
pilafs113511023pilafs
pili66130353pili__
piling95025593piling
pilis75825203pili_s
pily96132733pil__y
policy133211513policy
polity113015863polity
purify14399153purify
qualify2235473qualify
ramify14268753ramify
rarify123210063rarify
ratify122610043ratify
reify114814973_reify
revivify2042923revivify
riley84420583ril_ey
riling74227973riling
salsify1334703salsify
signify1444853signify
silica8311243silica
silicify1644273silicify
silkily14236963silkily
silky125315823sil_ky
sillily10209783sillily
silly84527623sil_ly
silty84721633sil_ty
simplify1843553simplify
slily85820033_slily
slimy105417423_slimy
spliff1438603spliff
tidily102811393tidily
tiling73426553tiling
tinily94014433tinily
typify1734523typify
uglily1036193uglily
unify113611113_unify
uplift114610653uplift
utility1038703utility
vagility1546323vagility
vailing113817943vailing
valid94618393vali_d
validly1435573validly
valine94623093valine
valise92917643valise
valley124311603valley
vanity12311933vanity
veiling113615293veiling
veiny115414363v_einy
verbify1834993verbify
verily122616053verily
verity123714853verity
versify1636333versify
viably14199833viably
vialing113614163vialing
vibist11610583vibist
vichy1639043vi_chy
vicing124014243vicing
viduity1445343viduity
viewy14518103vi_ewy
vigia94813273vigi_a
vigias104110893vigias
vigil94313003vigi_l
vigils104210193vigils
viking143414613viking
vile76139803vil__e
viler86324163vil_er
vilest9416843vilest
vilified1547243vilified
vilifier1456693vilifier
vilifies1439593vilifies
vilifying1944493vilifying
vill75235073vil__l
villa85321233vil_la
villae95615383villae
villainy1444873villainy
villas96117263villas
villi86517853vil_li
vills86429323vil_ls
villus93611223villus
vimina11339943vimina
vinery124912603vinery
vinic10314973vini_c
vinier93716743vinier
vining104619463vining
viny106025953v__iny
violin9311983violi_n
violins10311453violins
violist10312143violist
virid94116043viri_d
virile9313433virile
virility1447733virility
virion9310683virion
visibly1535043visibly
vising103915873vising
vision9311313vision
visit8320963visi_t
visits9311423visits
visive1257873visive
vitality1458113vitality
vivary1536983vivary
vivid125112313vivi_d
vividly1744233vividly
vivific1843363vivific
vizier184311023vizier
vizir17359393vizi_r
vizirs18306713vizirs
volery1237873volery
voling103918023voling
volley12419743volley
wildly13328123wildly
wilier93217073wilier
wiling103024293wiling
willy115321913wil_ly
wily106428813wil__y
wirily123310783wirily
zincify2443913zincify
zinkify2643123zinkify

Search took 6 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 Filter1786911127160.580308087.9
2DLD Change Limit1127162415.20321663.7
3Display Results2412410.0932591.4
 (SQL Overall)1786912415.87630410.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.