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

259 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
atabal83974(None) 
atabals938411atabals
anabas8314082anabas
ataman81013062ataman
atonal6514022atonal
atrial65418942atrial
cabal95222152_cabal
sabal75422482_sabal
statal61613222statal
tabla73318362_tabla
tamal73522632_tamal
tubal75517202_tubal
aal39058673__a_al
aba512850953__aba_
abaca95118043abaca_
abacas104414723abacas
abaka114313823abaka_
abakas123911743abakas
abas68642083__abas
abaxial1646183abaxial
abaya104413173abaya_
abayas114011703abayas
abba810522653a_bba_
abbas95918653a_bbas
aboral8314373aboral
acaudal1045783acaudal
acetal84314903acetal
actable11313473actable
actinal9312293actinal
actual8311023actual
adagial946373adagial
adaxial1545323adaxial
aecial84817313aecial
aerial64625713aerial
agama85815583agama_
agamas97413453agamas
agapae9388043agapae
agapai9456863agapai
agonal7410053agonal
airbag956963airbag
alanyl955483alanyl
alba68328333a_lba_
albas75925393a_lbas
algal66518223a_lgal
amatol838693amatol
ameba9312383ameba_
amebae1049633amebae
ameban1039103ameban
amebas10311453amebas
amoral8314633amoral
anal48037523__anal
animal85016253animal
annal56520763a_nnal
anneal64812303anneal
annual64710703annual
anodal72512123anodal
antral65719413antral
anural65714743anural
aortal65217513aortal
apical10913903apical
apneal83411123apneal
apodal9289833apodal
appal95315223a_ppal
appeal103911613appeal
apteral9311523apteral
arabic10312733arabic
arable81821003arable
areal55928743a_real
argal65023403a_rgal
arrayal1055843arrayal
artal55525483a_rtal
arval86017023a_rval
asana5315483asana_
asanas6514113asanas
astragal945623astragal
astral66919283astral
ataghan1144653ataghan
atalaya1044823atalaya
atamans9710433atamans
atap66722453at__ap
ataps76414833ata_ps
ataraxy1743983ataraxy
atavic11189293atavic
ataxia13179593ataxia
ataxias14189343ataxias
ataxic15169203ataxic
ataxy1537313ata_xy
atlas55821583at_las
atlatl637873atlatl
atma68121783at_ma_
atman75520153at_man
atmas75721023at_mas
atoll57913923at_oll
atria56022353atria_
attaboy1264303attaboy
attar56516693at_tar
audial7312993audial
aural54428963a_ural
avail8313883ava_il
avatar937523avatar
avowal1246323avowal
axal116520493__axal
axial124515193a_xial
axonal1347653axonal
azonal1568273azonal
baal67033113_ba_al
baba88828353_baba_
babas96325733_babas
babel95821693_babel
babul96317713_babul
bal56662723___bal
banal75925993_banal
barbal104016673barbal
basal75722283_basal
bathyal1544823bathyal
bharal1138893bharal
biaxal1536093biaxal
bubal94218213_bubal
cabala103516913_cabala
cabals104020153_cabals
canal75428043_canal
carabao1139673carabao
caracal11312513caracal
casaba1079263casaba_
casabas1139983casabas
catawba1443703catawba_
catawbas1544093catawbas
coaxal15387303coaxal
craal74117753cra_al
cymbal15236913cymbal
databank1542643databank
database1143533database
datable101714233datable
datival1135583datival
eatable91717603eatable
fatal84819373_fatal
gayal9312713_gayal
gimbal11228813gimbal
global937663global
graal64316503gra_al
hadal95518123_hadal
halal85623593_halal
hamal104623123_hamal
hatable121713963hatable
herbal112513493herbal
hiatal9310203hiatal
jacal14313703_jacal
jumbal1758463jumbal
kabab134814453_kabab
kabala124011553_kabala
kabar114815563_kabar
kraal94511833kra_al
label75019383_label
labial84714343_labial
lateral7313573lateral
mastaba1146223mastaba_
mastabah1554023mastabah
mastabas1246803mastabas
matambala1581863matambala
matinal9312603matinal
meatal84114733meatal
nasal56217593_nasal
natal53921493_natal
natural739513natural
naval85315833_naval
oatmeal944973oatmeal
octaval1243583octaval
palatal9310153palatal
papal95820673_papal
pataca10311193pataca_
patacas11311003patacas
patagial1157173patagial
patamar1147093patamar
pibal95217323_pibal
plagal948573plagal
qabala17399193_qabala
rabat72832223_rabat
ramal74622253_ramal
ratable91717553ratable
ratably121711513ratably
ratal55025113_ratal
ratatat7412263ratatat
ratbag956563rat_bag
sabals84618863_sabals
salal55425703_salal
sambal105215183sambal
satara6315533satara_
sataras7315063sataras
seabag938473seabag
stab67329933stab__
stabile9312063stabile
stable83921643stable
stably113314123stably
stabs76221383stab_s
stalag7310023stalag
stall54722353sta_ll
stanol6310723stanol
steal56125473st_eal
stibial946583stibial
stomal85213313stomal
stratal72710603stratal
tab57460323_tab__
tabard9313333_tabard
tabby125213893_tabby
taber73825823_taber
tabes76033923_tabes
tabid84418263_tabid
tablas83716163_tablas
table75429603_table
taboo73418093_taboo
tabor75518393_tabor
tabs66842983_tab_s
tabu66328493_tab_u
tabuli839363_tabuli
tabun75914373_tabun
tabus74820923_tabus
tael46030713_ta_el
tail45443653_ta_il
taka87623593_taka_
takas95520683_takas
tala45938053_tala_
talar56225383_talar
talas55935893_talas
tall47240213_ta_ll
tamale83717403_tamale
tamals84116633_tamals
tambac122210243tambac
tambak14249263tambak
tambala1138023tambala
tapa65129153_tapa_
tapalo839793_tapalo
tapas74627713_tapas
tarnal63716513tarnal
tarsal63315283tarsal
tatar56122063_tatar
taxa116820103_taxa_
taxol124011363_taxol
teal45546503_t_eal
tepal76319583_tepal
tetanal738023tetanal
tibial849843_tibial
tical76021493_tical
tidal64516453_tidal
timbal102510753timbal
tombal102311023tombal
tonal53724303_tonal
total55321823_total
trial54926353_trial
tribal8611133tribal
tuba65422363_tuba_
tubae74716643_tubae
tubas75119583_tubas
tymbal13236823tymbal
typal105311153_typal
vagal94613633_vagal
vasal85516293_vasal
vatical1239983vatical
verbal112513663verbal
yatagan1144133yatagan

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162595.62620034.8
3Display Results2592590.0932784.9
 (SQL Overall)1786912596.10929250.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.