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

301 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
kabala12401155(None) 
cabala103516911cabala
kabaka11348501kabaka
kabalas133911061kabalas
kabaya15387121kabaya
kabbala1584611kabbala
kamala12339961kamala
qabala17399191qabala
abaca95118042_abaca
abaka114313822_abaka
abaya104413172_abaya
cabal95222152cabal_
cabalas113516002cabalas
cabals104020152cabals
cabana103913562cabana
cabbala1367182cabbala
falbala1235872falbala
halala94715092halala
hawala12368912hawala
kabab134814432kaba_b
kababs14409762kababs
kabakas12367402kabakas
kabar114815552kaba_r
kabars124513952kabars
kabayas16316802kabayas
kabbalah1962432kabbalah
kabbalas1674352kabbalas
kamalas13339122kamalas
kanaka9357522kanaka
kibla1139832kib_la
koala95112212k_oala
labara83712892labara
masala8311812masala
qabalah21285032qabalah
qabalas18289502qabalas
sabal75422482sabal_
sabals84618862sabals
tabla73318362tab_la
tambala1138022tambala
aal39058673_a_al_
aals49941143_a_als
aba512850953_ab__a
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
abba810522643_ab_ba
abele76323253_abele
abelia83114403_abelia
able66340533_ab_le
ably99725133_ab_ly
abolla8410193_abolla
aboma91114603_aboma
abulia83512503_abulia
agama85815573_agama
akela9311343_akela
ala312463603___ala
albata839333albata
alula5317093_alula
anal48037523_anal_
argala74712663argala
asana5315483_asana
asyla839333_asyla
atabal839743atabal_
atabals938413atabals
axal116520493_axal_
azalea1537003_azalea
baa510650423__ba_a
baal67033113ba_al_
baals76122703ba_als
baba88828343__baba
babas96325733baba_s
babble94017113babble
babel95821693babel_
babels105216723babels
babka137812913bab_ka
babul96317713babul_
babuls105413643babuls
bacalao1146613bacalao
bacula103112673bacula
bal56662723__bal_
balas76937213__balas
balata8614673balata
bald76432903__bald
bale66353843__bale
balk105132223__balk
ball66043323__ball
balm85534203__balm
bals66354043__bals
balsa77920413__balsa
banal75925993banal_
banana83213413banana
barbal104016663barbal_
basal75722283basal_
basalt83519583basalt
bola66035563__bola
bubal94218213bubal_
bubale104014623bubale
bubals103513843bubals
cabanas112413033cabanas
cabbalah1763793cabbalah
cabbalas1467373cabbalas
cable95329913cab_le
calla74827073ca_lla
canal75428043canal_
canals84421663canals
canola8313623canola
cantala94114673cantala
canula8312963canula
casaba1079263casaba
casava1157873casava
catalo8314853catalo
catalpa1136503catalpa
cavalla1257883cavalla
cicala10310053cicala
coala77521123_coala
cobalt10317393cobalt
dabble114515193dabble
dobla84913643dob_la
embalm1236643embalm
fable105824753fab_le
fabular12288693fabular
facula112912233facula
falbalas1345473falbalas
fatal84819373fatal_
favela1237033favela
fibula11258053fibula
gabble113815723gabble
gable85325523gab_le
gala55635163__gala
gayal9312713gayal_
gayals1039513gayals
habdalah1742613habdalah
habile11515203habile
hadal95518123hadal_
halal85623593halal_
halalah13429383halalah
halalas104214083halalas
halals95018313halals
hamada1239913hamada
hamal104623103hamal_
hamals114816813hamals
hawalas13348353hawalas
ikebana1342693ikebana
imbalm1246303imbalm
impala10256923impala
jacal14313703jacal_
jacals1539873jacals
jacana1537933jacana
kaas86531843ka_a_s
kab97145853kab___
kabalism1647043kabalism
kabalist14410083kabalist
kabbalahs2051903kabbalahs
kabiki1134773kabiki
kabob134113923kab_ob
kabobs14439293kabobs
kabs107130843kab__s
kabuki1143963kabuki
kahuna1394103kahuna
kaiak8310353kaia_k
kaiaks937043kaiaks
kail85131493ka_il_
kails95525213ka_ils
kaka76518683k__aka
kakapo1143853kakapo
kakas85117343kaka_s
kalam11315113kala_m
kalams12310603kalams
kale86533753k__ale
kalmia1238893kalmia
kalpa114512193ka_lpa
kana85928523k__ana
kanakas10327213kanakas
kanas95326913kana_s
kanban1238623kanba_n
kanbans1337723kanbans
kapa106021293k__apa
kapas116021733kapa_s
kappa13469743ka_ppa
karat96837593kara_t
karate105320923karate
karats106420493karats
karma113415003ka_rma
kasbah1535183kasba_h
kasbahs1634363kasbahs
kasha124710723ka_sha
kata85626023k__ata
katas95922093kata_s
kava115819703k__ava
kavas125919953kava_s
kavass13517303kavass
kayak1138363kaya_k
kayaks1236333kayaks
kbar106514653k_ba_r
kbars114612603k_bars
kebab134311993keba_b
kebabs14418503kebabs
kebar115113533keba_r
kebars124112493kebars
keblah1545313keblah
kibble143910953kibble
kiblah1535583kiblah
kiblas1239323kiblas
kinara10310363kinara
koalas104011663k_oalas
kobold1365963kobold
kola85124963k__ola
kraal94511823kraal_
kraals10378433kraals
label75019383label_
labella988943labella
labels84515683labels
labia75219003lab_ia
labial84714333labial_
labials9299873labials
labile8315213labile
labra75415463lab_ra
lambada1245643lambada
macula103013673macula
manana84816073manana
mandala10310203mandala
manila84518303manila
maraca10314153maraca
marsala939583marsala
masalas9312053masalas
nagana748943nagana
nala46930393__nala
napalm1047263napalm
nasal56217593nasal_
nasals63312463nasals
natal53921493natal_
naval85315833naval_
nebula857333nebula
nyala836823_nyala
pabular11259473pabular
paella8410913paella
pajama17317653pajama
palapa10310673palapa
panada94113053panada
panama104213343panama
papal95820673papal_
papaya1337503papaya
papula103011113papula
pataca10311193pataca
payola11208113payola
pibal95217323pibal_
pibals103813083pibals
qabalahs22253293qabalahs
rabat72832223raba_t
rabato83413263rabato
rabats83116223rabats
rabble103818243rabble
radula749313radula
ramada9310183ramada
ramal74622243ramal_
rambla103510933rambla
ranula6311813ranula
ratal55025113ratal_
ratals64219583ratals
ribald9209293ribald
robalo838923robalo
sable74732163sab_le
sabra75317853sab_ra
salal55425703salal_
salals65120083salals
samara8313853samara
sambal105215183sambal_
sambals115213483sambals
satara6315533satara
subalar9118073subalar
tabard9313333tabard
tablas83716163tablas
table75429603tab_le
tabular9279763tabular
tabuli839363tabuli
tala45938053__tala
tamal73522613tamal_
tamale83717393tamale
tamals84116623tamals
tambalas1237033tambalas
tampala1136613tampala
tapalo839793tapalo
tarama8412723tarama
tubal75517203tubal_
unbale83616403unbale
vagal94613633vagal_
vasal85516293vasal_
wabble133714843wabble
wabbly16348363wabbly
walla85321033wa_lla
yamalka1652963yamalka
zanana153810363zanana

Search took 7 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 Limit1127163015.95318934.3
3Display Results3013010.0933236.6
 (SQL Overall)1786913016.18628886.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.