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

107 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
vanadic133674(None) 
anodic92813132_anodic
fanatic12610702fanatic
faradic1337692faradic
gonadic1177212gonadic
hagadic1445862hagadic
maenadic1344612maenadic
monadic1268882monadic
vanadium1444712vanadium
vandalic1446112vandalic
venatic12311522venatic
acidic113612133_acidic
agamic113110563_agamic
agaric93513643_agaric
aggadic1254813aggadic
agnatic10310973agnatic
amidic114012873_amidic
anadem939183_anadem
anaemic1149903_anaemic
anemic102713693_anemic
anisic8313793_anisic
anomic102516303_anomic
anoxic152610673_anoxic
antic75728863_an_tic
anuric8812113_anuric
arabic10312733_arabic
asdic83814093_a_sdic
atavic11189293_atavic
ataxic15169203_ataxic
aviatic1239243aviatic
balladic1345333balladic
banausic1242833banausic
bandaid11310483bandaid
bandit93821133ban_dit
bardic11312923ba_rdic
canakin131810833canakin
candid104517853can_did
cannabic1474913cannabic
canonic11312933canonic
canopic1338803canopic
cantic103920543can_tic
dryadic1443633dryadic
dyadic1336093_dyadic
dynamic1545813dynamic
enatic8317563_enatic
enneadic1142773enneadic
fanatics1367183fanatics
fanfic1436313fan_fic
faradaic1443653faradaic
fatidic1345723fatidic
fundic12389083fun_dic
gonidic1166103gonidic
haggadic1643073haggadic
halakic1656663halakic
hexadic2045413hexadic
jalapic1844543jalapic
lanai5319573lana_i_
lanais6316793lana_is
lunatic938753lunatic
manakin131810643manakin
mandalic1347803mandalic
manganic1346993manganic
manic94629443man__ic
mantic104120903man_tic
mantric11311353mantric
monodic1269783monodic
nadir61012973__nadir
nandin7313033nan_din
naric76824173__naric
nomadic1248033nomadic
octadic1245713octadic
paladin101011773paladin
palladic1346113palladic
panada94113053panad_a
panadas103312213panadas
pandit93820753pan_dit
panic93923903pan__ic
parodic122311723parodic
saccadic1244173saccadic
santalic1048893santalic
satanic939933satanic
scandic1237003scan_dic
syndic1237303syn_dic
synodic1347363synodic
tannic82811473tan_nic
tantalic1048053tantalic
tantric939593tantric
tornadic1144843tornadic
triadic1037833triadic
valeric1238303valeric
vanadate1245513vanadate
vanadiate1344443vanadiate
vanadiums1543223vanadiums
vanadous1246033vanadous
vanda94515923van_d_a
vandal103713833van_dal
vandals113211663vandals
vandas103915993van_das
vaned94622423vaned__
vanillic1344263vanillic
vatic10316423v__atic
veridic1338143veridic
viatic11311453v_iatic
vinic10314973vin__ic
vinylic1543883vinylic
vocalic1446943vocalic
xanthic1945863xanthic

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271076.72019944.5
3Display Results1071070.0303566.7
 (SQL Overall)1786911077.14025026.8
 
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.