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

171 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
tambala113802(None) 
tambalas1237031tambalas
tampala1136611tampala
cabala103516912ca_bala
cabbala1367182cabbala
falbala1235872falbala
kabala124011552ka_bala
kabbala1584612kabbala
kamala12339962kam_ala
lambada1245642lambada
matambala1581862matambala
qabala17399192qa_bala
rambla103510932ramb_la
sambal105215182sambal_
sambals115213482sambals
tabla73318362ta_b_la
tamable11312842tamable
tamal73522612tam_al_
tamale83717392tam_ale
tamals84116622tam_als
tambac122210242tamba_c
tambacs13219362tambacs
tambak14249262tamba_k
tambaks15218152tambaks
tambura11326462tambura
tampalas1245472tampalas
timbal102510752timbal_
timbale11248802timbale
timbals11239532timbals
tombal102311022tombal_
tombola1146092tombola
tymbal13236822tymbal_
tymbals14265722tymbals
abaca95118043_a_baca
abaka114313823_a_baka
abaya104413173_a_baya
albata839333_albata
ambage11510603_ambage
ambari103012163_ambari
ambary134010543_ambary
amble95924643_amb_le
argala74712663_argala
atabal839743atabal_
atabals938413atabals
barbal104016663barbal_
cabal95222153ca_bal_
cabalas113516003ca_balas
cabals104020153ca_bals
cabana103913563ca_bana
cabbalah1763793cabbalah
cabbalas1467373cabbalas
cambia124913153camb_ia
cambial134010763cambial_
cantala94114673cantala
cembali13156043cembali
cembalo13145533cembalo
cymbal15236913cymbal_
cymbals16236143cymbals
damiana1046563damiana
embalm1236653_embalm
falbalas1345473falbalas
gamba106018513gamb__a
gambade1336383gambade
gambado1344973gambado
gambas115817513gamba_s
gambia115912243gamb_ia
gamble115417183gamb_le
gambol1138223gambol_
gambols1238593gambols
gimbal11228813gimbal_
gimbals12257823gimbals
gumball1266833gumball
halala94715093ha_lala
hamada1239913ham_ada
hamal104623103ham_al_
hamals114816813ham_als
hammada1545083hammada
hammal134512063hammal_
hammals14409213hammals
hawala12368913ha_wala
imbalm1246323_imbalm
impala10256933_impala
jambalaya2351063jambalaya
jumbal1758463jumbal_
jumbals18106533jumbals
kabaka11348503ka_baka
kabalas133911063ka_balas
kabaya15387123ka_baya
kabbalah1962433kabbalah
kabbalas1674353kabbalas
kamalas13339123kam_alas
labara83712893la_bara
lambadas1354873lambadas
lambast11129893lambast
lambda1146113lamb_da
lamella988603lamella
mamba116317523mamb__a
mambas125716243mamba_s
mammal95112753mammal_
mammals10389273mammals
mandala10310203mandala
marsala939583marsala
masala8311813ma_sala
namable11312333namable
qabalah21285033qa_balah
qabalas18289503qa_balas
ramada9310183ram_ada
ramal74622243ram_al_
ramblas112710263ramblas
ramble104519973ramb_le
sabal75422483sa_bal_
sabals84618863sa_bals
samara8313853sam_ara
samba95618773samb__a
sambaed1238303sambaed
sambar103914163samba_r
sambars115113843sambars
sambas104219263samba_s
sambuca1344343sambuca
samsara936913samsara
tabard9313333ta_bard
tablas83716163ta_blas
table75429603ta_b_le
tabular9279763ta_bular
tabuli839363ta_buli
takable13310193takable
tala45938053t___ala
tamales93216143tam_ales
tamarao977583tam_arao
tamarau9107053tam_arau
tamari8313383tam_ari
tamasha12125423tamasha
tambour1136343tambour
tamboura1253883tamboura
tambur10358713tamb_ur
tamburas12316043tamburas
tamburs11288603tamburs
tameable1238603tameable
tamely113711953tam_ely
tampan102512323tampa_n
tampans113310983tampans
tanbark1337373tanbark
tantara72410813tantara
tapalo839793ta_palo
tarama8412723ta_rama
tarnal63716503tarnal_
tarsal63315273tarsal_
tarsals72512603tarsals
tartana73010193tartana
taxable1639073taxable
taxably1936043taxably
timbales12227843timbales
timbral11237193timbral_
timpana11226123timpana
tombac12258883tomba_c
tomback17227743tomback
tombacs13248433tombacs
tombak14237753tomba_k
tombaks15246853tombaks
tombolas1245993tombolas
tombolo1146103tombolo
trapball1244753trapball
trehala1045953trehala
tribal8611133tribal_
tribals9610743tribals
tubal75517203t_ubal_
tumble103215643tumb_le
tympana14255853tympana
wamble134415753wamb_le
wambly16388663wamb_ly
yamalka1652963yam_alka

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271718.17316398.8
3Display Results1711710.0463717.4
 (SQL Overall)1786911718.37521336.2
 
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.