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

170 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
kabaya1538712(None) 
abaya104413171_abaya
kabaka11348501kabaka
kabala124011551kabala
kabayas16316801kabayas
abaca95118042_abaca
abaka114313822_abaka
abayas114011702_abayas
cabala103516912cabala
cabana103913562cabana
kabab134814432kaba_b
kababs14409762kababs
kabakas12367402kabakas
kabalas133911062kabalas
kabar114815552kaba_r
kabars124513952kabars
kabbala1584612kabbala
kamala12339962kamala
kanaka9357522kanaka
labara83712892labara
papaya1337502papaya
qabala17399192qabala
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
abba810522643_ab_ba
ably99725133_ably_
aboma91114603_aboma
aby810238063_ab_y_
abye97921003_ab_ye
abys97221883_ab_ys
agama85815573_agama
albata839333albata
aliya83713483_aliya
asana5315483_asana
atalaya1044823atalaya
away108024223_away_
baa510650423__ba_a
baba88828343__baba
babas96325733baba_s
babka137812913bab_ka
baby116723673bab_y_
balata8614673balata
banana83213413banana
bay89661643__bay_
bays97143913__bays
cabal95222153caba_l
cabalas113516003cabalas
cabals104020153cabals
cabanas112413033cabanas
cabbala1367183cabbala
cabby145314553cabby_
casaba1079263casaba
casava1157873casava
embay123410593embay_
embays131408323embays
falbala1235873falbala
gabby135512943gabby_
gaby107123193gab_y_
gamay116419103gamay_
gamays126310903gamays
halala94715093halala
hamada1239913hamada
hawala12368913hawala
ikebana1342693ikebana
jacana1537933jacana
kaas86531843ka_a_s
kab97145853kab___
kabbalah1962433kabbalah
kabbalas1674353kabbalas
kabiki1134773kabiki
kabob134113923kab_ob
kabobs14439293kabobs
kabs107130843kab__s
kabuki1143963kabuki
kahuna1394103kahuna
kaiak8310353kaia_k
kaiaks937043kaiaks
kaka76518683k__aka
kakapo1143853kakapo
kakas85117343kaka_s
kalam11315113kala_m
kalams12310603kalams
kalmia1238893kalmia
kalpa114512193ka_lpa
kamalas13339123kamalas
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
kaury12429763kaury_
kava115819703k__ava
kavas125919953kava_s
kavass13517303kavass
kay106745543k__ay_
kayak1138363kaya_k
kayaks1236333kayaks
kayo116417553k__ayo
kays116032193k__ays
kbar106514653k_ba_r
kbars114612603k_bars
kebab134311993keba_b
kebabs14418503kebabs
kebar115113533keba_r
kebars124112493kebars
kibla1139833kib_la
kinara10310363kinara
koala95112213k_oala
labia75219003lab_ia
labra75415463lab_ra
lambada1245643lambada
manana84816073manana
maraca10314153maraca
masala8311813masala
maya95824583__maya
nagana748943nagana
pajama17317653pajama
palapa10310673palapa
panada94113053panada
panama104213343panama
papayan1445303papayan
papayas1437273papayas
pataca10311193pataca
piraya1167713piraya
pitaya1186603pitaya
playa105812943_playa
qabalah21285033qabalah
qabalas18289503qabalas
rabat72832223raba_t
rabato83413263rabato
rabats83116223rabats
ramada9310183ramada
raya75224823__raya
sabal75422483saba_l
sabals84618863sabals
sabayon1244233sabayon
sabra75317853sab_ra
samara8313853samara
satara6315533satara
satay84718463satay_
satays94411683satays
tabard9313333tabard
tabby125213883tabby_
tabla73318363tab_la
tambala1138023tambala
tarama8412723tarama
yabby15389743yabby_
zanana153810363zanana

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161708.01614061.4
3Display Results1701700.1101545.5
 (SQL Overall)1786911708.26621617.6
 
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.