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

346 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
barbate1131454(None) 
abate76627842_a_bate
arbute8311042_arbute
baccate131011262baccate
barbal104016662barba_l
barbe95328282barb__e
barbet104427882barbet_
barbets114915842barbets
barbette1249112barbette
barbie105018352barb_ie
barbule1137942barbule
barbut104617002barbut_
barbuts11439842barbuts
barite84224812bar_ite
barrage10710852barrage
barrater10310152barrater
barware12610702barware
baryte115312882bar_yte
berate84729022ber_ate
borate85026152bor_ate
bursate94111202bursate
carate84734002car_ate
garbage1138052garbage
karate105320922kar_ate
narrate7313492narrate
parbake1538352parbake
sorbate9311732sorbate
variate101316432variate
abase76023483_a_base
abated95918453_a_bated
abater85518123_a_bater
abates85825033_a_bates
ablate82219213_ablate
abrade9313053abr_ade
abrogate11129603abrogate
acerbate1247533acerbate
acuate8315633_acuate
adnate72913483_adnate
aerate64830553_aerate
agate66525153_a_gate
agnate73314883_agnate
airdate8311323airdate
alate55340333_a_late
albata839333_albata
albite8313313_albite
ambage11510603_ambage
ansate64517863_ansate
arable81821003_arable
arame75026623_ar_ame
arbiter939933_arbiter
arbutes939703_arbutes
arcade91013643_arcade
arcane81216743_arcane
arcuate9311963_arcuate
areae55229743_area_e
arete56031353_ar_ete
arhat8327093_arhat_
arhats9312973_arhats
aubade939223_aubade
aurate64426473_aurate
aureate72515283aureate
aviate9315203_aviate
baba88828353ba_ba__
babas96325733ba_ba_s
babbitt1038033babbitt
babble94017113ba_bble
babe86835823ba_b__e
baccae12119703bacca_e
baccated15148373baccated
backbite1899173backbite
backdate1748223backdate
baggage1235633baggage
balata8614683ba_lata
baldpate1345483baldpate
ballade104012563ballade
ballute938543ballute
bandage11311023bandage
bandmate1347973bandmate
baobab946403baoba_b
baobabs1044443baobabs
barathea1345293bar_athea
barb85240063barb___
barbaric1446383barbaric
barbarity1645063barbarity
barbarize2246243barbarize
barbasco1443143barbasco
barbecue14194703barbecue
barbed115121313barb_ed
barbel104317073barb_el
barbell11429963barbell
barbels114514433barbels
barbeque21134063barbeque
barber104419323barb_er
barbered13259543barbered
barbers114317503barbers
barbes104526233barb_es
barbettes1348163barbettes
barbicel14144963barbicel
barbies114519593barbies
barbing123716993barbing
barbital1247053barbital
barbitone1354653barbitone
barbs95928193barb__s
barbules1238043barbules
barbwire1543863barbwire
barca91319433barca__
barcas101016603barca_s
barde85330773bar__de
bare65460523bar___e
bareback1846093bareback
bareboat1249943bareboat_
bareboats1345843bareboats
barege94713543bar_ege
barest85327693barest_
bargain1079063bargain
barge85631023bar__ge
bargee94624453bar_gee
barista9310823barista
barites94322333bar_ites
barmaid1238203barmaid
barman103519703barma_n
barmie103816393bar_mie
barnacle1245943barnacle
baronage1147073baronage
baronet91022213baronet
baronne938273baronne
baroque1835113baroque
barque17239553bar_que
barrable1249253barrable
barrack1538253barrack
barraged1297693barraged
barrages11711093barrages
barraters1138043barraters
barrator1048403barrator
barratry13114473barratry
barre75929553bar__re
barret84930493barret_
barrets94917103barrets
barrette1039793barrette
barter85525383bar__ter
barwares13610093barwares
barye105021493bar__ye
baryta114310293bar_yta
barytas12378283barytas
barytes124611153bar_ytes
basmati1148233basmati
baste74829983ba__ste
bate66552423___bate
batiste939743batiste
baubee103215993baub_ee
bauble103813213baub_le
bauxite1635573bauxite
bawbee132714233bawb_ee
bearable121512363bearable
bearcat11611913bearcat_
bearcats1267023bearcats
bedmate1239433bedmate
berake124216083ber_ake
berated104422133ber_ated
berates94126873ber_ates
bereave1258353bereave
bilobate1247033bilobate
binate8419773b_inate
birdbath1643173birdbath
bistate9313823bistate
bivariate1445303bivariate
blate75933783b__late
borage93917013bor_age
borane84620213bor_ane
borated104116363bor_ated
borates94823013bor_ates
bornite9311183bornite
brabble10349973brabble
brace95629273b_r_ace
brae65639113b_r_a_e
brake116025343b_r_ake
brat66055543b_r_at_
brats75336013b_r_ats
brave104925503b_r_ave
braze165423453b_r_aze
breath113916263b_reath
breathe123711843b_reathe
bromate11313553bromate
brute75321783b_r_ute
bubale104014623b_ubale
bugbane1255863bugbane
bullate93415073bullate
burble104617703burb_le
burbot10815653burbot_
burbots1168673burbots
burette939853burette
burgage1136633burgage
burkite1337003burkite
bursae84515603bursa_e
cabbage1446983cabbage
carafe115416163car_afe
carat75048793car_at_
carates95630613car_ates
carats85929023car_ats
carbamate1546023carbamate
carbarn1139453carbarn
carbide126112493carbide
carbine112918643carbine
carbonate13410513carbonate
carcase11312743carcase
carfare12310073carfare
carinate103320253carinate
carnage10311743carnage
carpale113414353carpale
cartage10312593cartage
carte75940423car__te
caseate9314783caseate
caudate10311353caudate
cerate84829463cer_ate
cirrate92413493cirrate
cordate10315223cordate
crate76537403_cr_ate
create85126383_create
curate85226243cur_ate
curtate9312643curtate
darbar959953darba_r
darbars10510093darbars
debate94419193_debate
derate74531233der_ate
ergate7315143_ergate
falcate12311623falcate
fermate122813003fermate
ferrate103014043ferrate
forbade13259103forbade
forbare122310513forbare
formate123115093formate
furcate12310453furcate
galeate83916793galeate
gallate83417133gallate
gambade1336383gambade
garage8314513gar_age
garbages1238183garbages
garbagey1543373garbagey
garbagy1444243garbagy
garble94118453garb_le
garote7717953gar_ote
garotte868703garotte
garrote8510113garrote
glabrate1146043glabrate
globate1057823globate
gradate9511233gradate
grate64932883_gr_ate
gyrate104912523gyr_ate
hamate113319833ha_mate
hastate10313913hastate
herbage1337013herbage
irate55627983_ir_ate
karat96837593kar_at_
karates115617473kar_ates
karats106420493kar_ats
labiate91313573labiate
lactate9312703lactate
lambaste12145013lambaste
lanate6421263la_nate
lariat6629043lariat_
lariated91212063lariated
lariats7615053lariats
larvae938843larva_e
laureate888023laureate
librate93214233librate
limbate1139213limbate
lobate82915243_lobate
lyrate94112103lyr_ate
magnate10512703magnate
makebate1645063makebate
malate84624563ma_late
maleate94117543maleate
mammate104411273mammate
mandate10315573mandate
marble104219103marb_le
marcato1139743marcato
marinate103017783marinate
marlite92917083marlite
marmite112413993marmite
muriate9313363muriate
narrated9310323narrated
narrater838723narrater
narrates8312763narrates
nervate1039533nervate
niobate937703niobate
ocreate93711743ocreate
orate55133303_or_ate
ornate6315143_ornate
palate84226793pa_late
paleate94120003paleate
palmate113215233palmate
palpate113213923palpate
parable111819773parable
parade94720643par_ade
parae76335703par_a_e
parbaked1735503parbaked
parbakes1638343parbakes
parkade1437583parkade
parlante1039693parlante
partake1339643partake
partite9317133partite
patriate10311933patriate
pirate82322883pir_ate
prate75135983_pr_ate
probate11414483probate
rabat72832223ra_bat_
rabato83413263ra_bato
rabats83116223ra_bats
radiate83416313radiate
ramate83921693ra_mate
rate45458763__r_ate
rebate84424113_rebate
sabbat10314713sabbat_
sabbath1445393sabbath
sabbats1138633sabbats
saccate111311763saccate
sarape84817573sar_ape
satiate7315403satiate
savate9313783sa_vate
seriate73722473seriate
serrate73017543serrate
sorbates10311103sorbates
striate74218953striate
surbase939793surbase
tannate71813523tannate
tartare73012683tartare
tartrate899683tartrate
ternate7415483ternate
trabeate1049483trabeate
tubate82813173_tubate
uprate83916543upr_ate
urate55432163_ur_ate
urbane82211383_urbane
vacate11314553va_cate
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
variated121211393variated
variates111214983variates
vibrate122811523vibrate
virgate1138733virgate
warble113516603warb_le
warfare1336733warfare
warpage1336403warpage
warpath1545203warpath
yardage1235733yardage

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.406440125.6
2DLD Change Limit1340273466.76619808.9
3Display Results3463460.1232813.0
 (SQL Overall)1786913467.29524495.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.