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 “variated” 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
variated12121139(None) 
lariated91212061lariated
variate101316431variate_
variates111214991variates
aviated11310272_aviated
carinated123414272carinated
labiated11109302labiated
marinated122513172marinated
muriated1139792muriated
narrated9310332narrated
patriated1238542patriated
radiated102512592radiated
satiated9311602satiated
seriated92717022seriated
striated93414152striated
vacated1349352va_cated
vaginated14328152vaginated
validated1446492validated
valuated12239202valuated
varied104817862vari__ed
variegated1543122variegated
variolated1445402variolated
vitiated12289222vitiated
abated95918453_a_bated
ablated102513443_ablated
aerated85322383_aerated
agisted938203_agisted
agitated1038413_agitated
airted74214503_a_irted
alated75625153_a_lated
animated111612373_animated
ansated84214003_ansated
arcaded1178973_arcaded
arcuated1138813_arcuated
ariled75620323_ari_led
arointed939003_arointed
arrased8149873_arrased
arrayed11117163_arrayed
aurated83817793_aurated
aviate9315213_aviate_
aviates10313083_aviates
awaited1146963_awaited
baccated15148383baccated
baited95319243ba_i_ted
barbate11314543barbate_
barite84224813bari_te_
barites94322343bari_tes
barraged1297703barraged
barrater10310153barrater
berated104422133ber_ated
bivariate1445303bivariate_
borated104116363bor_ated
capitated14159043capitated
carate84734003car_ate_
carates95630613car_ates
caried94528693cari__ed
carinate103320253carinate_
carpeted1338963carpeted
carted98631443car__ted
caryatid1447953caryatid
caseated11310723caseated
caudated1238063caudated
caveated1439143caveated
cavitated15177353cavitated
cerated103922473cer_ated
charioted1595873charioted
ciliated11510953ciliated
covariate1446213covariate_
covariates1545783covariates
crated94827773_cr_ated
created104323463_created
curated104717583cur_ated
darted84620923dar__ted
derated93623503der_ated
deviated13311053deviated
divaricated1853493divaricated
drifted12367953_drifted
emaciated1446933emaciated
eradiated11178813eradiated
evacuated15196263evacuated
evaginated1575133evaginated
evaluated13276653evaluated
expiated18168523expiated
fabricated1845403fabricated
fainted114211723fa_inted
falcated1438483falcated
farted105121783far__ted
fasciated1546133fasciated
filiated12610083filiated
floriated1347023floriated
foliated1249913foliated
fritted113611333_fritted
furcated1437593furcated
gaited84416923ga_i_ted
galeated104111583galeated
garaged1039253gar_aged
garoted9710133gar_oted
garotted1066193garotted
garreted1057523garreted
garroted1056793garroted
glaciated1365763glaciated
gradated1157433gradated
grated84523923_gr_ated
grifted12379583_grifted
gritted94110903_gritted
gyrated12428413gyr_ated
habited1337883habi_ted
herniated1346013herniated
irrigated1176313irrigated
irritated1076133irritated
karate105320933kar_ate_
karates115617473kar_ates
labiate91313573labiate_
labiates101011523labiates
lactated1138873lactated
laminated122610283laminated
lanated8313203la_nated
lapidated1345673lapidated
lariat6629053lariat__
lariats7615063lariat_s
laureated1096163laureated
loricated1247903loricated
lyrated11388473lyr_ated
mandated12310293mandated
marginated14187343marginated
marinaded13276533marinaded
marinate103017783marinate_
marinates112516393marinates
marketed1537323marketed
marted94425213mar__ted
mediated123011873mediated
merited10313853meri_ted
muriate9313363muriate_
muriates10312093muriates
muricated1448243muricated
narrate7313493narrate_
narrater838723narrater
narrates8312763narrates
navigated1445483navigated
obviated1444573obviated
opiated1039483_opiated
orated74221503_or_ated
overhated16610443overhated
overrated13313083overrated
paginated13309463paginated
painted104214633pa_inted
palliated1238503palliated
palmated132511003palmated
palpated13249763palpated
paraded114014263par_aded
parbaked1735503parbaked
parented11912213parented
pargeted1238683pargeted
parietes10714553parietes
parlayed1435823parlayed
parroted1158853parroted
parted94228683par__ted
patinated123911413patinated
patriate10311933patriate_
patriates11311373patriates
pirated102515613pir_ated
prated94924923_pr_ated
printed104016373_printed
radiate83416313radiate_
radiates92415303radiates
radicated13410123radicated
rarified1239053rarified
rated65441383__r_ated
rifted104115313__rifted
rioted73416373__rioted
sainted84114243sa_inted
salivated1337473salivated
sanitated1068993sanitated
satiate7315403satiate_
satiates8314633satiates
scripted13117573scripted
seriate73722473seriate_
seriates82620683seriates
serrated92513433serrated
sprinted113411163sprinted
striate74218953striate_
striates83417093striates
tainted83512423ta_inted
targeted1037483targeted
tariffed1533723tariffed
tarted74923373tar__ted
tartrated1096653tartrated
threated1259203threated
throated1247923throated
treated83618703_treated
triaged92810443_triaged
unrated82621553unr_ated
uprated103213323upr_ated
urinated9311613_urinated
vacate11314553va_cate_
vacates12312833va_cates
vaccinated1855443vaccinated
vacillated1654633vacillated
vaginate123911083vaginate_
vailed104619293va_i_led
valeted1139013va_leted
validate1239003validate_
validates1338243validates
vallate103016563vallate_
valuate102512733valuate_
valuates112811203valuates
valvate133710813valvate_
vanished15207763vanished
vanitied12138213vanitied
varia85824213varia___
variable13310063variable
variables1444683variables
variably1637433variably
variance1397413variance
variances14117373variances
variant10316803varia_nt
variants1139203variants
varias95019913varia__s
variating13310953variating
variation12312393variation
varices123313573vari_ces
varicosed1543863varicosed
variegate1344103variegate_
variegates1444043variegates
varier94619353vari__er
varies94330873vari__es
varietal1145613varietal
varieties1259213varieties
variety1337743variet_y
variolate1248553variolate_
variolates1347463variolates
variole10711593variole_
varioles11711133varioles
varisized2244493varisized
varistor1146393varistor
varnished16195613varnished
varoomed1445293varoomed
varved134110603var__ved
vatted104214733va__tted
vaulted11307193va_ulted
vaunted11438863va_unted
verified151510403verified
veritates12310973veritates
verite94323443veri_te_
verites103822263veri_tes
vesicated15117653vesicated
vialed105112593v__ialed
vibrated14228393vibrated
vicariate1476353vicariate_
vicariates1565533vicariates
violated1237883violated
virgate1138733virgate_
virgates1237923virgates
visited1168773visi_ted
vitiate103412953vitiate_
vitiates112311433vitiates
vomited1337253vomi_ted
waisted114210943wa_isted
waited103819773wa_i_ted
warranted1345013warranted
warted104223233war__ted

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461622617.75018859.6
3Display Results2612610.1102372.7
 (SQL Overall)1786912618.28021581.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.