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

203 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
qabalas1828950(None) 
cabalas113516001cabalas
kabalas133911061kabalas
qabala17399191qabala_
qabalah21285031qabalah
qabalahs22253291qabalahs
abacas104414722_abacas
abakas123911742_abakas
abayas114011702_abayas
balas76937212__balas
cabala103516912cabala_
cabals104020152cabal_s
cabanas112413032cabanas
cabbalas1467372cabbalas
falbalas1345472falbalas
halalas104214082halalas
hawalas13348352hawalas
kabakas12367402kabakas
kabala124011552kabala_
kabayas16316802kabayas
kabbalas1674352kabbalas
kamalas13339122kamalas
masalas9312052masalas
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
canals84421673canal_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_
imbalms1334553imbalms
impalas11236953impalas
jacales16310323jacales
jacals1539873jacal_s
jacanas1638263jacanas
kababs14409773kaba_bs
kabaka11348503kabaka_
kabalism1647043kabalism
kabalist14410083kabalist
kabars124513953kaba_rs
kabaya15387123kabaya_
kabbala1584613kabbala_
kabbalah1962433kabbalah
kabbalahs2051903kabbalahs
kamala12339963kamala_
kanakas10327213kanakas
kiblas1239323kib_las
koalas104011663_koalas
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
qanats154112813qana_ts
qualms17317243q_ualms
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 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 Filter1786911340270.453394461.4
2DLD Change Limit1340272037.33018284.7
3Display Results2032030.0762671.1
 (SQL Overall)1786912037.85922737.1
 
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.