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

261 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
vinify153692(None) 
minify1439251minify
vilify1536771vilify
vivify1834701vivify
citify1437442citify
dignify1543892dignify
ignify1334512ignify
lignify1443792lignify
nidify1336762nidify
signify1444852signify
tinily94014432tinily
unify113611112_unify
vanity12311932vanity
verify153110162verify
vinery124912602vinery
vinic10314972vini_c
vinier93716742vinier
vining104619462vining
viny106025952vin__y
vitrify1645002vitrify
zincify2443912zincify
zinkify2643122zinkify
acidify1645243acidify
aerify122810113aerify
airily93014823airily
aminity12310513aminity
avidity1436483avidity
basify1437513basify
biffy164711133bi_ffy
binary11312223binary
binit76431583bini_t
binits85716673binits
bovinity1645023bovinity
carnify1555883carnify
codify1537163codify
cornify1536253cornify
damnify1643453damnify
dandify15245673dandify
deify124112763_deify
densify1435293densify
dignity1236453dignity
dimity12310473dimity
dingey114914053dingey
dinghy14476963dinghy
dingily1238103dingily
dingy105721263din_gy
dining84525133dining
dinkey144812763dinkey
dinkly144311083dinkly
dinky135819373din_ky
divinity1546163divinity
edify12308563_edify
fancify1834983fancify
finely123011563finely
finery124512893finery
finial92814183finial
finicky1943713finicky
fining104223213fining
finis86824263fini_s
finish124613413finish
finite9316823finite
finito9310303finito
finny114716753fin_ny
fixity19427803fixity
gasify1336333gasify
ginny95314573gin_ny
gonif94320923gonif_
goniff13408893goniff
gonifs104310133gonifs
hinky155618753hin_ky
hinny115616673hin_ny
icily101211693_icily
iffy135312283_i_ffy
inby95315663_in_by
infix15337773_infix
info75617353_in_fo
inia45024703_ini_a
inion54620183_inion
inky115321583_in_ky
inlay85214323_inlay
inly75622213_in_ly
jiffy21458313ji_ffy
jiminy1836273jiminy
jingly174111933jingly
kindly14358843kindly
kingly143511303kingly
kinin94917323kini_n
kinins104014583kinins
kinkily1335223kinkily
kinky115816383kin_ky
knife1210010133_knife
lenity9612713lenity
lindy96918313lin_dy
lineny94011443lineny
liney87029633lin_ey
lingy96925143lin_gy
linier64423793linier
linin58025523lini_n
lining74526803lining
linins65922143linins
linky127622383lin_ky
linsey938993linsey
linty87126563lin_ty
liny78141323lin__y
liquify2244033liquify
lithify1644763lithify
magnify1634533magnify
micrify1744693micrify
miffy163910203mi_ffy
mincy125817413min_cy
mingy115520183min_gy
mini65634563mini__
minim97321603mini_m
minima105512653minima
minims104514813minims
mining94225453mining
minion83416243minion
minis75432993mini_s
minish115216303minish
minium106014423minium
minny104518663min_ny
minty106323903min_ty
modify1537173modify
nazify2134233nazify
nifty115211633__nifty
nigrify1444133nigrify
ninety9510963ninety
ninny84514933nin_ny
nitrify1335793nitrify
nixy145714513__nixy
notify1236943notify
oilily93111723oilily
ossify1244973ossify
pacify1667473pacify
pinery115214293pinery
piney105727503pin_ey
pinier84024693pinier
pining93726533pining
pinion83815893pinion
pinite8321243pinite
pinkey154314673pinkey
pinkly155012243pinkly
pinky145823403pin_ky
pinny105222063pin_ny
piny911838353pin__y
punily11311773punily
purify14399153purify
rainily10310433rainily
ramify14268753ramify
rarify123210063rarify
ratify122610043ratify
reify114814973_reify
resinify1445053resinify
reunify1344453reunify
revivify2042923revivify
rindy95717393rin_dy
salify12311373salify
sanity9316203sanity
shinily13268933shinily
sinewy12667513sinewy
singly104015853singly
sniff113915863_sniff
sniffy15337193sniffy
tidily102811393tidily
tingly103815973tingly
tinier63622233tinier
tining74927543tining
tinkly134811153tinkly
tinnily1047363tinnily
tinny85317653tin_ny
tiny76134633tin__y
trinity10310843trinity
typify1734523typify
uglify1333913uglify
unity84918493_unity
vainly1258503vain_ly
vanish121513213vanish
veinier10269583veinier
veining114713893veining
veiny115414363v_einy
venery123710663venery
venial94218283venial
venin85118663veni_n
venine93718433venine
venins93816703venins
venire93513693venire
verbify1834993verbify
verily122616053verily
verity123714853verity
versify1636333versify
viably14199833viably
vibist11610583vibist
vichy1639043vi_chy
vicing124014243vicing
vicinity1645813vicinity
viduity1445343viduity
viewy14518103vi_ewy
vigia94813273vigi_a
vigias104110893vigias
vigil94313003vigi_l
vigils104210193vigils
viking143414613viking
vilely1239443vilely
vimina11339943vimina
vina76331803vin__a
vinal85725813vin_al
vinals94716483vinals
vinas85126343vin_as
vinca105315163vin_ca
vincas113912453vincas
vincibly1843583vincibly
vine75643683vin__e
vineal94814743vineal
vined95626153vin_ed
vines85137643vin_es
viniest103216613viniest
vinifera1443453vinifera
vinified1537543vinified
vinifies1439873vinifies
vinifying1944713vinifying
vino76128433vin__o
vinos84723073vin_os
vinosity1445733vinosity
vinous93914173vinous
vinyl115311623vin_yl
vinyls12467003vinyls
virid94116043viri_d
virile9313433virile
virion9310683virion
visibly1535043visibly
vising103915873vising
vision9311313vision
visit8320963visi_t
visits9311423visits
visive1257873visive
vivary1536983vivary
vivid125112313vivi_d
vividly1744233vividly
vivific1843363vivific
vizier184311023vizier
vizir17359393vizi_r
vizirs18306713vizirs
vyingly1794153vyingly
wilily123310763wilily
wincey144110383wincey
windily1437943windily
windy126118103win_dy
winery125014283winery
winey115325433win_ey
wingy126521033win_gy
winier94522453winier
wining103625053wining
winish124212263winish
wintry12498923wintry
winy107034323win__y
wirily123310783wirily
zanily18310183zanily
zincky24404963zincky
zincy195413513zin_cy
zingy186516133zin_gy
zinky215314813zin_ky

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.393454684.5
2DLD Change Limit1127162614.76323664.9
3Display Results2612610.0803262.5
 (SQL Overall)1786912615.23634127.4
 
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.