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

202 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
abaca95118042_abaca
abaka114313822_abaka
abaya104413172_abaya
abba810522652_ab_ba
baba88828352__baba
babas96325732baba_s
babka137812912bab_ka
balata8614672balata
banana83213412banana
baobab946402baobab_
baobabs1044442baobabs
bubba84311802bub_ba
cabala103516912cabala
cabana103913562cabana
casaba1079262casaba
kabab134814442kabab_
kababs14409772kababs
kabaka11348502kabaka
kabala124011552kabala
kabaya15387122kabaya
labara83712892labara
qabala17399192qabala
aba512850953___aba
abacas104414723_abacas
abaci94718843_abaci
aback134816173_aback
abaft10318063_abaft
abakas123911743_abakas
abamp11310603_abamp
abas68642083_aba_s
abase76023483_abase
abash106016513_abash
abasia8712953_abasia
abate76627843_abate
abayas114011703_abayas
abbacy1536623abbacy
abbas95918643abba_s
abbe87627193_ab_be
aboma91114603_aboma
agama85815583_agama
alba68328333_a_lba
albata839333albata
ameba9312383_ameba
anabas8314083_anabas
asana5315483_asana
atabal839743_atabal
baa510650423__ba_a
baaed85218163ba_aed
baal67033113ba_a_l
baals76122703ba_als
baas66844673ba_a_s
babassu1153463babassu
babble94017113babble
babe86835823__babe
babel95821693bab_el
babels105216723babels
babes95834113bab_es
babesia1146623babesia
babied114913513babied
babier103515573babier
babies106123653babies
babkas146010143babkas
baboo94319503bab_oo
babool103012153babool
baboon103613913baboon
baboos103517013baboos
babu85829233__babu
babul96317713bab_ul
babuls105413643babuls
babus95620333bab_us
baby116723683__baby
babysat14135233babysat
bacalao1146613bacalao
bacca111012183ba_cca
baccara1347143baccara
bacula103112673bacula
badass949293badass
bagass938933bagass
baiza164813223ba_iza
baklava1643103baklava
baklawa1643403baklawa
balas76937213bala_s
balatas9311833balatas
balboa10389963balboa
balsa77920413ba_lsa
banal75925993bana_l
bananas93312223bananas
banda85223103ba_nda
bandana10179463bandana
barb85240063ba_rb_
barbal104016663barba_l
barbate11314543barbate
barbe95328283ba_rbe
barbs95928193ba_rbs
barca91319433ba_rca
baryta114310293baryta
basal75722283basa_l
basalt83519583basalt
bayamo1335603bayamo
bayard124411663bayard
bazaar17306403bazaar
bazar163816003baza_r
bazars174613113bazars
bemata10411693bemata
bibb75819213bib_b_
bibbs84911583bib_bs
blab86629133b_lab_
blabby1234813blab_by
blabs95619633b_labs
bobby114814663bob_by
brava106414793b_rava
braza165214253b_raza
bubal94218213buba_l
bubale104014623bubale
bubals103513843bubals
bubbas94110703bubbas
bubby115013933bub_by
bwana10310243b_wana
cabal95222153caba_l
cabalas113516003cabalas
cabals104020153cabals
cabanas112413033cabanas
cabbala1367183cabbala
cabby145314563cab_by
cabob114616813cabob_
cabobs124311893cabobs
cabomba1544083cabomba
carabao1139673carabao
caramba1336893caramba
casabas1139983casabas
casava1157873casava
cassaba1145663cassaba
catawba1443703catawba
dagoba1074943dagoba
falbala1235873falbala
gabby135512953gab_by
galabia1038323galabia
gamba106018513ga_mba
gazabo1834833gazabo
halala94715093halala
hamada1239923hamada
hawala12368913hawala
indaba935633indaba
jacana1537933jacana
kabakas12367403kabakas
kabalas133911063kabalas
kabar114815553kaba_r
kabars124513953kabars
kabayas16316803kabayas
kabbala1584613kabbala
kabob134113933kabob_
kabobs14439303kabobs
kamala12339963kamala
kanaka9357523kanaka
kebab134312003kebab_
kebabs14418513kebabs
labia75219013lab_ia
labra75415463lab_ra
lambada1245643lambada
lavabo1135273lavabo
mamba116317523ma_mba
manana84816073manana
maraca10314153maraca
masala8311813masala
mastaba1146223mastaba
nabob93913743nabob_
nabobs10388213nabobs
nagana748943nagana
nawab10810923nawab_
nawabs1185063nawabs
pajama17317653pajama
palabra1137183palabra
palapa10310673palapa
panada94113053panada
panama104213353panama
papaya1337503papaya
pataca10311193pataca
piasaba1144193piasaba
qabalah21285033qabalah
qabalas18289503qabalas
rabat72832223raba_t
rabato83413263rabato
rabats83116223rabats
rabbi93113183rab_bi
ramada9310183ramada
sabal75422483saba_l
sabals84618863sabals
sabbat10314713sabbat
sabra75317853sab_ra
samara8313853samara
samba95618773sa_mba
satara6315533satara
tabard9313333tabard
tabby125213893tab_by
tabla73318363tab_la
tambala1138023tambala
tarama8412733tarama
wasabi1154643wasabi
yabby15389753yab_by
zanana153810363zanana
zareba1736423zareba
zariba1736983zariba

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162025.73619650.6
3Display Results2022020.0633206.3
 (SQL Overall)1786912025.93930087.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.