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

252 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
kabalas13391106(None) 
cabalas113516001cabalas
kabakas12367401kabakas
kabala124011551kabala_
kabayas16316801kabayas
kabbalas1674351kabbalas
kamalas13339121kamalas
qabalas18289501qabalas
abacas104414722_abacas
abakas123911742_abakas
abayas114011702_abayas
balas76937212__balas
cabala103516912cabala_
cabals104020152cabal_s
cabanas112413032cabanas
cabbalas1467372cabbalas
falbalas1345472falbalas
halalas104214082halalas
hawalas13348352hawalas
kababs14409772kaba_bs
kabaka11348502kabaka_
kabalism1647042kabalism
kabalist14410082kabalist
kabars124513952kaba_rs
kabaya15387122kabaya_
kabbala1584612kabbala_
kabbalah1962432kabbalah
kabbalahs2051902kabbalahs
kamala12339962kamala_
kanakas10327212kanakas
kiblas1239322kib_las
koalas104011662k_oalas
masalas9312052masalas
qabala17399192qabala_
qabalah21285032qabalah
qabalahs22253292qabalahs
sabals84618862sabal_s
tablas83716162tab_las
tambalas1237032tambalas
aals49941143_a_al_s
abaca95118043_abaca_
abacus10349763_abacus
abaka114313823_abaka_
abamps1236253_abamps
abas68642083_ab__as
abases85720773_abases
abasias9711013_abasias
abates85825033_abates
abatis84317933_abatis
abaya104413173_abaya_
abbas95918643_ab_bas
abeles84719393_abeles
abelias93213563_abelias
ables75935543_ab_les
abomas101113583_abomas
abulias93210693_abulias
agamas97413453_agamas
akelas10311193_akelas
alas46358123___alas
albatas938373albatas
anabas8314083_anabas
anlas55626933_a_nlas
argalas84011093argalas
asanas6514113_asanas
atabals938413atabal_s
atlas55821583_a_tlas
azaleas1636993_azaleas
baals76122703ba_al_s
baas66844673__ba_as
babas96325733__babas
babbles104416323babbles
babels105216723babel_s
babkas146010143bab_kas
babuls105413643babul_s
bacalao1146613bacalao
bacalaos1245863bacalaos
balatas9311833balatas
balds85524643__balds
bales76250083__bales
balks114926293__balks
balls76236413__balls
balms95723923__balms
bals66354043__bal_s
balsa77920413__balsa
balsas86417523__balsas
bananas93312223bananas
basalts9358963basalts
bolas74733763__bolas
bubales113513343bubales
bubalis11359903bubalis
bubals103513843bubal_s
cabal95222153cabal__
cabalism14310143cabalism
cabalist12314503cabalist
cabana103913563cabana_
cabbala1367183cabbala_
cabbalah1763793cabbalah
cabbalahs1862723cabbalahs
cables104527553cab_les
callas84526753ca_llas
canals84421663canal_s
canolas9313993canolas
cantalas104013523cantalas
canulas9312853canulas
casabas1139983casabas
casavas1237823casavas
catalase1039223catalase
catalos9414163catalos
catalpas1246733catalpas
cavallas1366843cavallas
cicalas1139303cicalas
coalas87418963_coalas
cobalts1139203cobalts
dabbles124514773dabbles
doblas93812293dob_las
embalms1335333embalms
fables114921673fab_les
fabular12288693fabular
falbala1235873falbala_
favelas1337023favelas
fibulas12228563fibulas
gabbles124415413gabbles
gables94222333gab_les
galas65731643__galas
gayals1039513gayal_s
habdalah1742623habdalah
habdalahs1842113habdalahs
halala94715093halala_
halalah13429393halalah
halalahs14367443halalahs
halals95018313halal_s
hamadas1339673hamadas
hamals114816823hamal_s
hawala12368913hawala_
ikebanas1442333ikebanas
imbalms1334553imbalms
impalas11236953impalas
jacales16310323jacales
jacals1539873jacal_s
jacanas1638263jacanas
kaas86531843k__a_as
kabab134814443kab__ab
kabalisms1745953kabalisms
kabalists1546293kabalists
kabar114815553kab__ar
kabbalism1943683kabbalism
kabbalist1744613kabbalist
kabikis1243863kabikis
kabobs14439303kab_obs
kabs107130843kab___s
kabukis1243193kabukis
kahunas1473953kahunas
kaiaks937043kaia_ks
kails95525213ka_il_s
kakapos1243673kakapos
kakas85117343k__akas
kalam11315113k__alam
kalams12310603kala_ms
kales95730983k__ales
kalmias1347973kalmias
kalpas124112943ka_lpas
kanaka9357523kanaka_
kanas95326913k__anas
kanbans1337723kanba_ns
kapas116021733k__apas
kappas144410363ka_ppas
karates115617473karates
karats106420493kara_ts
karmas123013733ka_rmas
kasbahs1634363kasba_hs
kashas133311903ka_shas
katas95922093k__atas
kavas125919953k__avas
kavass13517303kava_ss
kayaks1236333kaya_ks
kayles134712003ka_yles
kbars114612603k_ba_rs
kebabs14418513keba_bs
kebars124112493keba_rs
keblah1545313keb_lah
keblahs1634563keblahs
kibbles153510253kibbles
kibla1139833kib_la_
kiblah1535583kib_lah
kiblahs1634153kiblahs
kinaras1159123kinaras
koala95112213k_oala_
kobolds1474343kobolds
kolas94822233k__olas
kraals10378433kraal_s
labara83712893labara_
labels84515683label_s
labials9299873labial_s
lambadas1354873lambadas
maculas113114023maculas
mananas93414733mananas
mandalas1139443mandalas
manilas93915873manilas
maracas11313773maracas
marsalas1038253marsalas
masala8311813masala_
naganas847983naganas
nalas55528363__nalas
napalms1144033napalms
nasals63312463nasal_s
nebulas957583nebulas
nyalas936903_nyalas
pabular11259473pabular
paellas9411413paellas
pajamas18278153pajamas
palapas11311493palapas
panadas103312213panadas
panamas113112763panamas
papayas1437273papayas
patacas11311003patacas
payolas12148973payolas
pibals103813083pibal_s
rabatos93010903rabatos
rabats83116223raba_ts
rabbles113517973rabbles
radulas839583radulas
ramadas1039303ramadas
ramblas112710263ramblas
ranulas7311773ranulas
ratals64219583ratal_s
ribalds10236673ribalds
robalos937683robalos
sabal75422483sabal__
sables85026693sab_les
sabras85116363sab_ras
salals65120083salal_s
samaras9312913samaras
sambals115213483sambal_s
sataras7315063sataras
subalar9118073subalar
tabards10310383tabards
tabla73318363tab_la_
tables84524893tab_les
tabular9279763tabular
tabulis938833tabulis
talas55935893__talas
tamales93216153tamales
tamals84116633tamal_s
tambala1138023tambala_
tampalas1245473tampalas
tapalos938813tapalos
taramas9612703taramas
unbales92914863unbales
wabbles144013993wabbles
wallas95719393wa_llas
yamalkas1743103yamalkas
zananas16319563zananas

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272525.65623696.4
3Display Results2522520.0932709.7
 (SQL Overall)1786912526.15529031.8
 
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.