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

182 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
kabaka1134850(None) 
abaka114313821_abaka
kabakas12367401kabakas
kabala124011551kabala
kabaya15387121kabaya
kanaka9357521kanaka
abaca95118042_abaca
abakas123911742_abakas
abaya104413172_abaya
babka137812912bab_ka
cabala103516912cabala
cabana103913562cabana
kabab134814432kaba_b
kababs14409762kababs
kabalas133911062kabalas
kabar114815552kaba_r
kabars124513952kabars
kabayas16316802kabayas
kabbala1584612kabbala
kabiki1134772kabiki
kabuki1143962kabuki
kaiak8310352kaiak_
kaiaks937042kaiaks
kaka76518682k__aka
kamala12339962kamala
kanakas10327212kanakas
kayak1138362kayak_
kayaks1236332kayaks
labara83712892labara
qabala17399192qabala
aba512850953_ab__a
abacas104414723_abacas
abaci94718843_abaci
aback134816173_aback
abaft10318063_abaft
abamp11310603_abamp
abas68642083_aba_s
abase76023483_abase
abash106016513_abash
abasia8712953_abasia
abate76627843_abate
abayas114011703_abayas
abba810522643_ab_ba
aboma91114603_aboma
agama85815573_agama
alaska1036713_alaska
albata839333albata
arak86929573_arak_
araks94820883_araks
asana5315483_asana
awake125014783_awake
baa510650423__ba_a
baba88828343__baba
babas96325733baba_s
babkas146010143babkas
bake105637513__bake
balata8614673balata
banana83213413banana
cabal95222153caba_l
cabalas113516003cabalas
cabals104020153cabals
cabanas112413033cabanas
cabbala1367183cabbala
casaba1079263casaba
casava1157873casava
falbala1235873falbala
gagaku1243813gagaku
haika125313793ha_ika
halakah17517953halakah
halakha17416583halakha
halala94715093halala
hamada1239913hamada
hawala12368913hawala
ikebana1342693ikebana
jacana1537933jacana
kaas86531843ka_a_s
kab97145853kab___
kabbalah1962433kabbalah
kabbalas1674353kabbalas
kabikis1243863kabikis
kabob134113923kab_ob
kabobs14439293kabobs
kabs107130843kab__s
kabukis1243193kabukis
kahuna1394103kahuna
kakapo1143853kakapo
kakas85117343kaka_s
kaki76520913k__aki
kalam11315113kala_m
kalams12310603kalams
kalmia1238893kalmia
kalpa114512193ka_lpa
kalpak11437243kalpak_
kalpaks12366163kalpaks
kamalas13339123kamalas
kamik105011553kamik_
kamiks11387913kamiks
kana85928523k__ana
kanas95326913kana_s
kanban1238623kanba_n
kanbans1337723kanbans
kapa106021293k__apa
kapas116021733kapa_s
kapok10448783kapok_
kapoks11347263kapoks
kappa13469743ka_ppa
karakul1042553karakul
karaoke1044903karaoke
karat96837593kara_t
karate105320923karate
karats106420493karats
karma113415003ka_rma
kasbah1535183kasba_h
kasbahs1634363kasbahs
kasha124710723ka_sha
kata85626023k__ata
katakana1142433katakana
katas95922093kata_s
kava115819703k__ava
kavakava1751153kavakava
kavas125919953kava_s
kavass13517303kavass
kayaked1474053kayaked
kayaker1354503kayaker
kbar106514653k_ba_r
kbars114612603k_bars
kebab134311993keba_b
kebabs14418503kebabs
kebar115113533keba_r
kebars124112493kebars
khaki1157643k_haki
kibla1139833kib_la
kinara10310363kinara
kishka1232963kishka
koala95112213k_oala
kulak858823kulak_
kulaki984293kulaki
kulaks976113kulaks
kyak105213633k_yak_
kyaks11459163k_yaks
labia75219003lab_ia
labra75415463lab_ra
lambada1245643lambada
latakia1146093latakia
manana84816073manana
maraca10314153maraca
marka114620793ma_rka
markka11416593markka
masala8311813masala
medaka1336343medaka
nagana748943nagana
pajama17317653pajama
palapa10310673palapa
panada94113053panada
panama104213343panama
papaya1337503papaya
parbake1538353parbake
parka115120883pa_rka
pataca10311193pataca
qabalah21285033qabalah
qabalas18289503qabalas
rabat72832223raba_t
rabato83413263rabato
rabats83116223rabats
ramada9310183ramada
sabal75422483saba_l
sabals84618863sabals
sabra75317853sab_ra
samara8313853samara
satara6315533satara
sifaka1353553sifaka
tabard9313333tabard
tabla73318363tab_la
taka87623593__taka
taluka10426773taluka
tambak14249263tambak_
tambaks15218153tambaks
tambala1138023tambala
tanka93817483ta_nka
tarama8412723tarama
yamalka1652963yamalka
zanana153810363zanana

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 Filter1786911127160.1731032896.0
2DLD Change Limit1127161826.84316471.7
3Display Results1821820.0632888.9
 (SQL Overall)1786911827.07925242.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.