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

140 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
cabbala136718(None) 
cabala103516911ca_bala
cabbalah1763791cabbalah
cabbalas1467371cabbalas
kabbala1584611kabbala
cabal95222152ca_bal_
cabalas113516002ca_balas
cabals104020152ca_bals
cabana103913562ca_bana
cabbage1446982cabbage
cabbagy1744012cabbagy
cabbalahs1862722cabbalahs
cantala94114672cantala
falbala1235872falbala
kabala124011552ka_bala
kabbalah1962432kabbalah
kabbalas1674352kabbalas
qabala17399192qa_bala
tambala1138022tambala
abaca95118043_a_baca
abaka114313823_a_baka
abaya104413173_a_baya
abba810522653_abb__a
abbacy1536623_abbacy
abbas95918643_abba_s
abolla8410193_abolla
albata839333_albata
argala74712673_argala
babble94017113babb_le
barbal104016663barbal_
cabanas112413033ca_banas
cabbaged1644383cabbaged
cabbages1537203cabbages
cabbagey1843213cabbagey
cabbalism1745683cabbalism
cabbalist1547643cabbalist
cabbed135416263cabb_ed
cabbie122913353cabb_ie
cabbies133115163cabbies
cabbing143613153cabbing
cabby145314563cabb__y
cable95329913ca_b_le
cabman123812503cabma_n
cabomba1544083cabomba
cabrilla1245833cabrilla
caecal103713733caecal_
calabaza2143463calabaza
calla74827073ca__lla
cambia124913153camb_ia
cambial134010763cambial_
canal75428043ca_nal_
canals84421673ca_nals
candela1089743candela
canella9310793canella
cannula937433cannula
canola8313623ca_nola
cantal84122033cantal_
cantalas104013523cantalas
cantals93919573cantals
cantata93811813cantata
canula8312963ca_nula
capable13313363capable
capably1639253capably
capybara1742783capybara
carbarn1139453carbarn
carbora11310703carbora
carnal83919213carnal_
carpal103716253carpal_
carpale113414353carpale
carpalia1247263carpalia
carpals113414633carpals
casaba1079263ca_saba
casava1157873ca_sava
casbah1337903casba_h
casbahs1436463casbahs
cascara1138313cascara
cassaba1145663cassaba
cassata938143cassata
cassava1255003cassava
casual81112863casual_
casuals91410523casuals
catalo8314853ca_talo
catalpa1136503ca_talpa
catcall1139153catcall
catfall1237393catfall
cattalo938423cattalo
catwalk1645323catwalk
caudal91611483caudal_
causal81413203causal_
causals91411183causals
cavalla1257883cavalla
cembali13156043cembali
cembalo13145533cembalo
cicala10310053c_icala
coala77521123c__oala
cobalt10317393c_obalt
cobble123615263cobb_le
crabbily1744343crabbily
cymbal15236913cymbal_
cymbals16236143cymbals
dabble114515193dabb_le
falbalas1345473falbalas
gabbard1336553gabbard
gabbart1248883gabbart
gabble113815723gabb_le
habdalah1742623habdalah
halala94715093ha_lala
hawala12368913ha_wala
kabaka11348503ka_baka
kabalas133911063ka_balas
kabaya15387123ka_baya
kabbalahs2051903kabbalahs
kamala12339963ka_mala
labara83712893la_bara
labella988943labella
labial84714343labial_
labials9299873labials
lambada1245643lambada
mandala10310213mandala
marsala939583marsala
masala8311813ma_sala
qabalah21285033qa_balah
qabalas18289503qa_balas
rabble103818243rabb_le
rambla103510933ramb_la
sabal75422483sa_bal_
sabals84618863sa_bals
sabbat10314713sabba_t
sabbath1445393sabbath
sabbats1138633sabbats
sambal105215183sambal_
sambals115213483sambals
scabbard1544203scabbard
scabbily1763943scabbily
scabble13168653scabb_le
tabla73318363ta_b_la
tambalas1237033tambalas
tampala1136613tampala
wabble133714843wabb_le
wabbly16348363wabb_ly

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271407.61017612.0
3Display Results1401400.0463043.5
 (SQL Overall)1786911408.06222164.6
 
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.