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

246 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
variole1071159(None) 
cariole9818341cariole
dariole8711161dariole
ovariole1144921ovariole
variola1068891variola
varioles11711121varioles
areole61017282_areole
ariose64818722_ariose
cabriole1276932cabriole
capriole1276912capriole
carioles10817072carioles
carriole1089862carriole
darioles9710692darioles
oriole6814292_oriole
ovarioles1244612ovarioles
parole84425252par_ole
vacuole1245372vacuole
vagile10310542vagi_le
variable13310062variable
variate101316432variate
varicose1346702varicose
variolar1176342variolar
variolas1168532variolas
variolate1248552variolate
variolite1248082variolite
various103113102various
virile9313432viri_le
agile65122263_agi_le
aioli5318313_a_ioli
airhole1048273airhole
aisle55223193_a_isle
alible8311973_alible
amole75724593_a_mole
anile54634463_ani_le
anisole71010833_anisole
anole55330383_a_nole
arable81821003_arable
areola6813673_areola
areolae7811733_areolae
areoles71016953_areoles
argle65421563_ar_gle
argol65317263_argol_
argols74514613_argols
argyle1066063_argyle
aridly105513703_aridly
ariel55228973_ariel_
ariels65119373_ariels
aril45843023_ari_l_
ariled75620323_ari_led
arils58732203_ari_ls
ariosi64313033_ariosi
arioso64312403_arioso
arise56436433_ari_se
arkose104911343_arkose
armhole1236943_armhole
arose55832083_ar_ose
article9310923_article
aureole738693aureole
auricle9139813auricle
avarice1238033avari_ce
axile126020513_axi_le
azole145118033_a_zole
barbule1137943barbule
barilla9310323barilla
barite84224813bari_te
baritone1058643baritone
braciole1246973braciole
braille939713braille
bricole112810493_bricole
bridle94115463_bridle
cabrioles1376363cabrioles
cabriolet1377483cabriolet
cajole154011183ca_jole
calicle113111433calicle
camisole1246173camisole
caprioled1464743caprioled
caprioles1376753caprioles
caracole12310363caracole
caribe103416753cari_be
carinae94318593carinae
carioca1139683carioca
carious93320283carious
carle74535703car__le
carol75128613car_ol_
caroled103717693car_oled
caroler93816753car_oler
caroli85918233car_oli
carols85124983car_ols
carpale113414353carpale
carrioles1169473carrioles
creole8913733_creole
darkle113813943dar_kle
dartle73714833dar_tle
earlobe946543earlobe
evadible1443973evadible
facile112514883faci_le
faille93414743fa_ille
farinose1136463farinose
farle86929243far__le
frijole1734583_frijole
garble94118453gar_ble
gargle84215463gar_gle
gargoyle1342503gargoyle
garigue935583garigue
garote7717953gar_ote
garrote8510103garrote
gloriole944303gloriole
grille74315743_grille
habile11515213habi_le
haole84820083ha__ole
karaoke1044903karaoke
labile8315223labi_le
larine63927043lari_ne
liriope944043liriope
maile75232223ma_i_le
manhole12311343manhole
manille92613273manille
maniple11249653maniple
marble104219103mar_ble
marigold1244093marigold
marine84230403mari_ne
maypole1446383maypole
narcose95910383narcose
nargile847653nargile
narial6317953narial_
narine63422553nari_ne
orioles7412993_orioles
ostiole739013ostiole
ovarial1037613ovarial_
overidle1248823overidle
panicle11129983panicle
parable111819773parable
parle75836163par__le
parol74826273par_ol_
paroled104217633par_oled
parolee94119643par_olee
paroles95025883par_oles
parols84722613par_ols
partible1238063partible
particle1239533particle
petiole9311303petiole
prole74527793_pr_ole
pyrrole1246033pyrrole
radiale83813523radiale
radicle103510713radicle
rampole1139693rampole
rathole10312053rathole
ravioli1055613ravioli
rifle85518333__rifle
rile45650533__ri_le
rille55728733__rille
role45851823__r_ole
safrole1037253safrole
sanicle91210263sanicle
sarode75317513sar_ode
scariose1037593scariose
tadpole1036143tadpole
taille63116923ta_ille
taphole1239773taphole
trifle94012883_trifle
triode75311893_triode
triol55521363_triol_
triolet73219523_triolet
triols66117803_triols
triose64715383_triose
triple84215923_triple
utricle937913utricle
vacuoles1345013vacuoles
vadose1037963va_dose
vaginae11377683vaginae
vahine123612113vahi_ne
vail75432553va_i_l_
vailed104619293va_i_led
vails85825933va_i_ls
vainly1258503va_inly
vakil1259793vaki_l_
vakils1337593vaki_ls
vale74937343va___le
validly1435573validly
valine94623093vali_ne
valise92917643vali_se
valvule1343663valvule
vamoose1235863vamoose
vamose1159283va_mose
vanilla10238743vanilla
vapidly1635063vapidly
varia85824203vari__a
variables1444673variables
variably1637433variably
variance1397413variance
variant10316803variant
varias95019903vari_as
variated121211393variated
variates111214983variates
varices123313573varices
varicocele1751243varicocele
varicosed1543853varicosed
varicoses1446653varicoses
varied104817863vari_ed
variedly1544753variedly
varier94619353vari_er
variers103712663variers
varies94330873vari_es
variety1337743variety
variform1645003variform
variolated1445403variolated
variolates1347463variolates
variolites1346673variolites
varioloid1344063varioloid
variolous1244983variolous
variorum1343593variorum
variously1547313variously
varix154313513vari__x
varlet9423503var__let
varoom11411413var_oom
varoomed1445293varoomed
varooms1248883varooms
varve115716853var__ve
vehicle15175253vehicle
verbile1249863verbile
verbose1237753verbose
verily122616053veri_ly
verite94323443veri_te
vernicle1346433vernicle
versicle1366583versicle
vesicle12217923vesicle
vile76139803v__i_le
viol76523593v__iol_
viola85915543v__iola
violet92620923v__iolet
viols86118103v__iols
virgule1144283virgule
virion9310683virio_n
virions1039873virions
visible1236923visible
vitriol1045693vitriol_
vitrioled1343423vitrioled
vitriols1145053vitriols
voile84719723v_oi_le
vole75236983v___ole
warble113516603war_ble
warily122915093wari_ly
warsle93112923war_sle
warstle10328013warstle
wavicle1534063wavicle
zorille1636673zorille

Search took 7 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.406440125.6
2DLD Change Limit1340272465.84322938.0
3Display Results2462460.0932645.2
 (SQL Overall)1786912466.34228175.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.