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

162 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
variola106889(None) 
variolar1176341variolar
variolas1168531variolas
variole10711591variole
areola6813672_areola
barilla9310322barilla
carioca1139682carioca
cariole9818342cariole
dariole8711162dariole
ovariole1144922ovariole
vanilla10238742vanilla
varia85824202vari__a
variolate1248552variolate
varioles11711122varioles
various103113102various
viola85915542v__iola
aioli5318313_a_ioli
areolae7811733_areolae
areolar779223_areolar
areolas71013863_areolas
areole61017283_areole
argala74712673_argala
argol65317263_argol_
argols74514613_argols
aria46245423_ari__a
aridly105513703_aridly
ariel55228973_ariel_
ariels65119373_ariels
aril45843023_ari_l_
arils58732203_ari_ls
ariose64818723_ariose
ariosi64313033_ariosi
arioso64312403_arioso
arista6415293_arista
armilla936993_armilla
aroma71220143_ar_oma
arroba898663_arroba
arugola844353_arugola
aureola747033aureola
axilla13289573_axilla
barillas10310193barillas
barista9310813barista
braciola1245273braciola
cabrilla1245833cabrilla
cabriole1276933cabriole
canola8313623ca_nola
capriole1276913capriole
carbora11310703carbora
carina84325323cari_na
carinal94318233carinal
cariocas1239663cariocas
carioles10817073carioles
carious93320283carious
carol75128613car_ol_
caroli85918233car_oli
carols85124983car_ols
carriole1089863carriole
crapola1136913crapola
curiosa9346643curiosa
darioles9710693darioles
farina94618233fari_na
farinha13357063farinha
gladiola10113413gladiola
gorilla836973gorilla
granola837913granola
hariana10310243hariana
harissa1035503harissa
hemiola12107003hemiola
jarina134014063jari_na
latilla737953latilla
mandola1039023mandola
manila84518303mani_la
manilla93012473manilla
manioca11358943manioca
maria75032883mari__a
marigold1244093marigold
marimba1354983marimba
marina84623413mari_na
mariposa1243703mariposa
marital92314183marital
marsala939583marsala
maxilla16248193maxilla
moviola1244823moviola
narcoma1145823narcoma
narial6317953narial_
oriole6814293_oriole
ovarial1037613ovarial_
ovarioles1244613ovarioles
papilla11127913papilla
parabola1246653parabola
parol74826273par_ol_
parole84425253par_ole
parols84722613par_ols
payola11208113pa_yola
pergola1067623pergola
perilla9311233perilla
pyrola1139003pyr_ola
ravioli1055613ravioli
rioja1236303__rioja
sarcoma1147403sarcoma
tapioca1144633tapioca
triol55521363_triol_
triols66117803_triols
vacuolar1353483vacuolar
vacuole1245373vacuole
vagile10310543vagi_le
vagina102710933vagi_na
vaginal11288403vaginal
vail75432553va_i_l_
vails85825933va_i_ls
vainly1258503va_inly
vakil1259793vaki_l_
vakils1337593vaki_ls
validly1435573validly
valvula1343253valvula
vanillas11228123vanillas
vapidly1635063vapidly
vara75530883var___a
variable13310063variable
variably1637433variably
variant10316803variant
varias95019903vari_as
variate101316433variate
varicella1492993varicella
varices123313573varices
varicose1346703varicose
varied104817863vari_ed
variedly1544753variedly
varier94619353vari_er
variers103712663variers
varies94330873vari_es
varietal1145613varietal
variety1337743variety
variform1645003variform
variolated1445403variolated
variolates1347463variolates
variolite1248083variolite
varioloid1344063varioloid
variolous1244983variolous
variorum1343593variorum
variously1547313variously
varix154313513vari__x
varna84516173var__na
varoom11411413var_oom
varooms1248883varooms
vascula1245853vascula
vatical1239983vatical
verily122616053veri_ly
vexilla1744663vexilla
villa85321233v__illa
viol76523593v__iol_
violas93713523v__iolas
viols86118103v__iols
virile9313433viri_le
virion9310683virio_n
virions1039873virions
vitriol1045693vitriol_
vitriols1145053vitriols
voila84813943v_oi_la
warily122915093wari_ly
zariba1736983zari_ba
zorilla1646023zorilla

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.403443402.0
2DLD Change Limit1340271626.40620922.1
3Display Results1621620.0503240.0
 (SQL Overall)1786911626.85926052.0
 
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.