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

399 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
darbars1051009(None) 
darbar959951darbar_
durbars1077971durbars
arbors84717882_arbors
barbers114317502barbers
carbarn1139452carbarn
carbarns1238562carbarns
dabbers123813212dabbers
damars93814992da_mars
dammars12308192dammars
darbies104216982darbies
darbs85323262darb__s
darers75921872dar_ers
darners83815772darners
darters84017602darters
daubers104610422daubers
debars94218042d_ebars
disbars10310322disbars
drawbars1483102drawbars
drears74614252d_rears
durbar968722durbar_
harbors12412412harbors
kabars124513952ka_bars
sambars115113842sambars
sardars83112902sardars
sarsars73512142sarsars
tartars73313402tartars
abas68642083_a_ba_s
abbas95918643_abba_s
afars85716513_a_fars
agars66120643_a_gars
airbags1036293airbags
albas75925393_alba_s
altars64518153_altars
ambari103012173_ambari
ambaris113112163_ambaris
ambary134010543_ambary
ambers104519583_ambers
anears63717183_anears
araks94820883_ar_aks
arbor74818113_arbor_
arbores94016033_arbores
arbours93910043_arbours
arbs66834733_arb__s
ardors74416873_ardors
areas55935773_area_s
argals75517713_argals
arhats9312973_arhats
ariary94114203_ariary
arias55438023_aria_s
armers85520273_armers
armors85017813_armors
arras55626133_arra_s
arrays95311683_arrays
arrears738843arrears
attars64515313_attars
babas96325733ba_ba_s
baobabs1044443baobabs
barbal104016663barba_l
barbaric1446363barbaric
barbarism1545963barbarism
barbarous1345623barbarous
barbate11314543barbate
barbels114514433barbels
barber104419323barber_
barbes104526233barb_es
barbets114915843barbets
barbies114519593barbies
barbs95928193barb__s
barbuts11439843barbuts
barcas101016603barca_s
barkers134318513barkers
bars66564093___bars
barters94223033barters
barware12610703barware
barwares13610093barwares
bazaars18275883bazaars
bazars174613113ba_zars
briars84814823_briars
bursars94510893bursars
busbars1138153busbars
cabals104020153ca_bals
cabers105023923ca_bers
caesars9410733caesars
calcars11312653calcars
cambers134017443cambers
carabaos1238073carabaos
carats85929023car_ats
carbaryl1544423carbaryl
carbaryls1644013carbaryls
carbons115418943carbons
carbora11310703carbora
carboras12311583carboras
carbos105122263carb_os
carboys144711783carboys
carbs96031463carb__s
carcass11310513carcass
carders104820353carders
careers95218783careers
carers85133963car_ers
carfare12310073carfare
carfares13310323carfares
carpals113414623carpals
carpers114521253carpers
carrs75730853car__rs
carters95327253carters
carvers124817533carvers
casbahs1436463casbahs
caviars1238623caviars
corbans11313173corbans
curbers115514383curbers
dabber114816963dabber_
dabblers13379363dabblers
dabbles124514773dabbles
dabs77139403da_b__s
dachas124113253dacha_s
dackers143417043dackers
dadas75819863da_da_s
daggas937973dagga_s
daggers103714913daggers
dagobas1145143dagoba_s
daikers124010313daikers
damans94715983da_mans
damar84117733da_mar_
dammar11438903dammar_
dammers123214273dammers
damners104112113damners
dampers123915693dampers
dancers103413093dancers
danders93921183danders
dangers94818213dangers
darb76033533darb___
darer65230793dar_er_
dares66146703dar__es
darics94314113dar_ics
darings93713653darings
darkens12409873darkens
darker114718693darker_
darkeys15356533darkeys
darkies124015753darkies
darkles124011933darkles
darks106727873dar__ks
darnels83710433darnels
darner74017303darner_
darns66927893dar__ns
darshans1286543darshans
dartboard1344253dartboard
dartboards1443883dartboards
darter75320363darter_
dartles84014133dartles
darts67635733dar__ts
dashers115016863dashers
dastard9279703dastard
dastards10278083dastards
datary10310243da_tary
daters74827373da_ters
daturas838773daturas
dauber94112013dauber_
daubery13396213daubery
daubes94913703daub_es
daubry12445483daub_ry
daubs85014563daub__s
daybeds14234473daybeds
daycare1355093daycare
daycares1454803daycares
daymare1375633daymare
daymares1445333daymares
daystars1243903daystars
dears65736883d__ears
debags104211063d_ebags
debar85517863d_ebar_
debark134210943d_ebark
debarks14388493d_ebarks
denars74621433d_enars
deodars937623deodars
derats74625063der_ats
derays105514253der_ays
derbies103016053derbies
dermas94116813derma_s
dewars105117073d_ewars
dharmas1356513dharma_s
dharnas1155373dharna_s
dibbers124013173dibbers
dinars75417563d_inars
dirams94413703dir_ams
dirhams13376313dirhams
dirtbags1242703dirtbags
disbar938513disbar_
dobbers123513253dobbers
dobras94811913dobra_s
dogears937513dogears
dollars83311023dollars
dorbugs1132983dorbugs
dormers104313923dormers
dorpers104113173dorpers
dorrs65520593dor__rs
dorsals84110843dorsals
dorsers83516303dorsers
drabs85119673d_r_abs
drags75521113d_r_ags
dramas95814653drama_s
drams86025833d_r_ams
drapers105313353drapers
drats66628373d_r_ats
drawbar13103193drawbar_
drawers113610073drawers
draws95119373d_r_aws
drays95819773d_r_ays
dreads84115023d_reads
dreams94513983d_reams
drear65016903d_rear_
dreary104611673d_reary
driers74516733d_riers
dryads11436623d_ryads
dryers10449273d_ryers
dubbers124011823dubbers
duras65727733dur_a_s
durians839573durians
durras74713373durra_s
durrs65519993dur__rs
earbuds1044633earbuds
earlaps936393earlaps
earmark1345653earmark
earmarks1444793earmarks
earners74016453earners
embars103812883_embars
eyebars1245333eyebars
farads104713273far_ads
farcers124713443farcers
farers95924053far_ers
farfals13268503farfals
farmers124315263farmers
ferbams1435743ferbams
forbare122310513forbare
forbears1337073forbears
friars93812093_friars
gabbard1336553gabbard
gabbards1445753gabbards
gabbart1248883gabbart
gabbarts1344063gabbarts
gabbers124612833gabbers
gambas115817513gamba_s
gambirs12359083gambirs
garbage1138053garbage
garbages1238183garbages
garbagy1444243garbagy
garblers113810283garblers
garbles104016923garbles
garboard1247243garboard
garboards1346363garboards
garbs86321413garb__s
garners83815983garners
garters84218233garters
gasbags1135473gasbags
gaydars1235803gaydars
gazars164811553ga_zars
haars85620473ha__ars
hangars114313493hangars
harass9313943har_ass
harbor11410723harbor_
harbours1346923harbours
hardass1139753hardass
harmers124116593harmers
harpers124916203harpers
hartals10313023hartals
herbals122710603herbals
isobars936593isobars
jabbers183610583jabbers
jaguars1535233jaguars
jarrahs1735453jarrahs
kababs14409773ka_babs
kabar114815553ka_bar_
kanbans1337723kanbans
kantars11310033kantars
karats106420493kar_ats
karmas123013733karma_s
kasbahs1634363kasbahs
kbars114612603__kbars
kebars124112493_kebars
labara83712893la_bara
labors84016413la_bors
lahars94013163la_hars
lambers113817113lambers
larboard1157663larboard
larboards1246983larboards
larders83516943larders
lariats7615053lariats
larkers113014513larkers
larvas9310233larva_s
lascars979013lascars
lazars153812393la_zars
lumbars11289763lumbars
maars74621633ma__ars
makars124612633ma_kars
malars85020683ma_lars
mambas125716243mamba_s
maras75443293mar_a_s
marblers12319233marblers
marbles114516653marbles
margays1337493margays
markas124717003marka_s
markers133516103markers
marrams11310123marrams
marrers93414313marrers
martyrs1234893martyrs
mimbars1397383mimbars
mortars93411523mortars
nabbers113710463nabbers
narwals1036983narwals
navars92810573na_vars
paras76143043par_a_s
parbake1538353parbake
parbakes1638343parbakes
pardahs13289673pardahs
parers85530743par_ers
pariahs123812343pariahs
parians93519733parians
parkas125018023parka_s
parkers133816873parkers
parlays123910453parlays
parlors9312913parlors
parrals94414573parrals
parrs75928673par__rs
parsers94118153parsers
partans94418283partans
paruras9310533paruras
rabats83116223ra_bats
radars71314673ra_dars
ragbags1135113ragbags
ratbags1035763ratbags
rears54739653__rears
rebars84019833_rebars
roars55622243__roars
sabals84618863sa_bals
sabbats1138633sabbats
sabers85224733sa_bers
sabirs85414633sa_birs
sabras85116363sabra_s
saggars93610683saggars
sambals115213483sambals
sambar103914163sambar_
sambas104219263samba_s
sambhars1544833sambhars
samburs11369343samburs
sandbars11108783sandbars
sangars83116253sangars
sansars73313913sansars
sarans64224433sar_ans
sardar73013173sardar_
sarsar63011843sarsar_
sartors7314973sartors
sirdars8228213sirdars
tabard9313333ta_bard
tabards10310383ta_bards
tabers84621573ta_bers
tabors84517113ta_bors
talars66021683ta_lars
tambacs13219363tambacs
tambaks15218153tambaks
tamburs11288613tamburs
tanbark1337373tanbark
tanbarks1445563tanbarks
tarmacs1138323tarmacs
tarpans92513533tarpans
tarsals72512603tarsals
tartans72615823tartans
tartar63214753tartar_
tartare73012683tartare
tarzans16329923tarzans
taskbars1452993taskbars
tatars64619793ta_tars
turbans939563turbans
turbary1236383turbary
unbars82113033_unbars
uprears9107493uprears
uproars986453uproars
varas86028193var_a_s
varias95019903varia_s
variers103712663variers
varnas94212823varna_s
verbals121910743verbals
warblers13319103warblers
warbles123215563warbles
warders113416813warders
warfare1336733warfare
warfares1436683warfares
warmers124514293warmers
warners103315563warners
warpers123413583warpers
warsaws1335763warsaws
yabbers14389353yabbers
yardarm13114533yardarm
yardarms14123333yardarms
yarders113211593yarders
yarners104312203yarners
yerbas11119293yerba_s
zaffars22325233zaffars
zarebas1836303zareba_s
zaribas1836043zariba_s

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 Limit1340273996.45320769.7
3Display Results3993990.1562557.7
 (SQL Overall)1786913997.01525472.7
 
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.