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

448 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
tectal8371325(None) 
rectal84418141rectal
tecta74215521tecta_
acetal84314902acetal
aecial84817312aecial
cecal94619112cec_al
cental84420962cental
decal85523232dec_al
dental74319172dental
ductal938992ductal
fecal105119212fec_al
fecial114714622fecial
festal94213562festal
fetal85623372fe_tal
meatal84114732meatal
mental84521602mental
metal75427382me_tal
nectar838852nectar
octal71214722_octal
petal76526892pe_tal
recital9412172recital
recoal84117982recoal
recta74220262recta_
rental63922032rental
rictal83113192rictal
septal84513382septal
setal56430902se_tal
tactual936202tactual
teal45546502te__al
tectum10328602tectum
telial65815362telial
tepal76319582te_pal
tergal72912832tergal
tertial7313862tertial
testa54822042testa_
testae64216252testae
textual1444602textual
thecal113310312thec_al
tical76021492tic_al
tictac1036562tictac
total55321822t_otal
vestal94615572vestal
abettal946073abettal
aceta74017353aceta_
acetals93411353acetals
acetyl11396553acetyl
acta69524803_acta_
actual8311023_actual
aecia73819283aecia_
aerial64625713aerial
aortal65217513aortal
artal55525483_artal
becalm1239203bec_alm
becap114315053bec_ap
bechalk1845813bechalk
becrawl1444583becrawl
benthal1247963benthal
benzal1739643benzal
bestial9311643bestial
beta66234133be_ta_
betas75528763be_tas
betel74419903be_tel
betta74916843betta_
bettas84913923bettas
brutal859383brutal
buccal1248243buccal
caecal103713733caec_al
cantal84122033cantal
ceca84820783cec_a_
centai84814783centai
centals94317053centals
centas85020703centas
central93114473central
cercal10314123cercal
cereal8315833cereal
cesta75419483cesta_
cestas85018543cestas
chital114313883chital
coal66939253__coal
coccal9310223coccal
coital84117053coital
costal85419513costal
crestal9312133crestal
curtal83914543curtal
dactyl1234983dactyl
deal56347413de__al
decadal1137243decadal
decaf114919443dec_af
decals93717713dec_als
decanal1038113decanal
decay114718483dec_ay
decimal1238083decimal
deckel134911043deckel
declaw1266703declaw
decretal1146353decretal
decrial10310323decrial
dedal75719023de_dal
delta66117773delta_
deltas74414823deltas
denial74720513denial
dentals83915393dentals
dentil74017883dentil
dermal93614353dermal
detail74516433de_tail
dextral1577003dextral
dicta84915633dicta_
distal73615773distal
dotal64919623_dotal
ducal84816423duc_al
eclat7523603_eclat
ectypal1442773_ectypal
edictal1046993edictal
egal55119433_e_gal
ejecta15337393ejecta_
entail61114343_entail
equal1449823_equal
estral64716513_estral
eta35834193_e_ta_
etas46432273_e_tas
eternal72910893eternal
extol1247893_extol
facial113615633facial
factual1246723factual
faecal11359813faec_al
fatal84819373_fatal
feal713940423fe__al
fecials123510333fecials
fecula113310053fecula
feral85424653fe_ral
ferial94621253ferial
feta76528903fe_ta_
fetas85624403fe_tas
fetial95716193fetial
feudal1037683feudal
focal104917673foc_al
foetal9311883foetal
fontal9313143fontal
fractal1237623fractal
genial74917613genial
genital849793genital
gentil74115123gentil
gestalt8411173gestalt
geta56627443ge_ta_
getas65421483ge_tas
hartal9415483hartal
heal75645693he__al
hectare1238473hectare
hectic132311523hectic
hectical1547943hectical
hector113312653hector
hemal104419803he_mal
hematal1238953hematal
heptad1237273heptad
herbal112513493herbal
hiatal9310203hiatal
hyetal1236543hyetal
instal6712193instal
jacal14313703jac_al
jackal1937613jackal
ketol95414003ke_tol
keypal1534893keypal
lactam10310943lactam
lacteal966823lacteal
leal46043273le__al
lectin82515013lectin
lector83514993lector
legal65715943le_gal
lentil64315393lentil
lepta75714393lepta_
lethal939803lethal
local74820273loc_al
meal65643173me__al
mecca1139933mecca_
meccas1239493meccas
medal86221333me_dal
medial93819863medial
menial84223033menial
mensal84615663mensal
menta74424423menta_
mescal104113493mescal
mesial84818083mesial
meta65932413me_ta_
metals84520893me_tals
metol75917813me_tol
mezcal19367853mezcal
mortal84616853mortal
natal53921493_natal
nectars938463nectars
nectary1246223nectary
neural6311993neural
neutral737923neutral
notal55221353_notal
nuchal11218883nuchal
octad81510653_octad
octan71313483_octan
octyl10136063_octyl
omental93210423omental
peal68648103pe__al
pecan91919033pec_an
pechan13511543pechan
pectase112410363pectase
pectate112214693pectate
pecten102711103pecten
pectic122913873pectic
pectin102615533pectin
pectoral121210503pectoral
pedal86022503pe_dal
penal75228373pe_nal
penial84120893penial
pentad9313763pentad
pentyl1138813pentyl
peptalk1554823peptalk
petals84719813pe_tals
peytral1287503peytral
pical95524373pic_al
portal84218463portal
postal84317533postal
racial83419243racial
ratal55025113_ratal
real45750293re__al
reata54225393reata_
reatas64021023reatas
recall83815733recall
recap95718023rec_ap
recitals1039783recitals
reclad9311873reclad
recoals94214633recoals
recoat84024273recoat
recoil84016723recoil
rectally1339713rectally
recti73619623rect_i
recto74520803rect_o
rector84019753rector
rectos85718793rectos
rectum103411283rectum
rectus83314633rectus
recusal968683recusal
redial74923113redial
redtail858713redtail
refutal1046943refutal
regal65023793re_gal
regnal74812933regnal
renal55929513re_nal
rentals74017483rentals
repeal84718293repeal
reseal64819653reseal
retag63618413re_tag
retail65522073re_tail
retax124517973re_tax
retial64724993retial
retotal739843retotal
retral64419743retral
reveal94115063reveal
sacral83414413sacral
seal45654373se__al
seconal9310073seconal
secpar1037933secpar
sect67443623sect__
sectary1238273sectary
sectile9311973sectile
sector83415933sector
sectoral10109543sectoral
sects75622893sect_s
segetal868383segetal
seitan62613233seitan
sendal73314993sendal
sepal77723003se_pal
septa75518083septa_
seral56336383se_ral
serial64625863serial
serval93913413serval
seta45637313se_ta_
setae56026223se_tae
sextan13389643sextan
sexual1338423sexual
social8813333social
special11310303special
spectral12246193spectral
spital83813873spital
statal61613223statal
steal56125473ste__al
sternal73411913sternal
stratal72710603stratal
tact67349033tact__
tactful1236163tactful
tactic10612753tactic
tactical1248843tactical
tactile9310613tactile
tacts76524123tact_s
tamal73522633t_amal
tapetal938273tapetal
tarnal63716513tarnal
tarsal63315283tarsal
tartan64217523tartan
tartar63214763tartar
tatar56122063t_atar
tea37353323te__a_
teak85930843te__ak
teals56234133te__als
team66238653te__am
tear45242883te__ar
teas45851493te__as
teasel63914983teasel
teat45963633te__at
teated74924023teated
teats55636813teat_s
teazel15368543teazel
tech95925443tec__h
teched124014433teched
techie11511723techie
techily1537123techily
techno1135953techno
techs106915833tec_hs
techy135612013tec_hy
tectite9310583tectite
tectorial11119033tectorial
tectrix1644263tectrix
tectums11306423tectums
teel46335803te__el
teeter65420313teeter
teeth87315853teet_h
teethe94511313teethe
teetotal844533teetotal
tegua6109563tegua_
teguas768013teguas
tel35647903te___l
tela45532973te_la_
telae54323293te_lae
telia55821143telia_
tell44934703te__ll
telltale844423telltale
tenail64516113tenail
tenia55324483tenia_
teniae64517353teniae
tenias64720073tenias
tent46159863tent__
tentacle1037693tentacle
tentage81010643tentage
tented74221003tented
tenter64623933tenter
tenth85421833tent_h
tenthly1335743tenthly
tenths94412663tenths
tentie62521183tentie
tents56434213tent_s
tenty86121603tent_y
teopan839353teopan
tepa66021683te_pa_
tepals85415043te_pals
tepas76521683te_pas
terai53525483te_rai
tercel83612993tercel
terga63315643terga_
terra54419673terra_
terrae62915213terrae
terras63516973terras
tertials8510073tertials
tertian7511193tertian
tesla55612603tesla_
teslas64212173teslas
test48651623test__
testable101412623testable
testacy1235963testacy
testate73916233testate
tested74421523tested
testee64323303testee
tester64227153tester
testes65125823testes
testily102910803testily
testis64916713testis
teston6313303teston
tests56530193test_s
testy85419063test_y
tet39274993te_t__
tetanal738023tetanal
tetany959843te_tany
tetchy1436003tetchy
teth76327893te_t_h
teths85418513te_ths
tetra53417953te_tra
tetrad73612053tetrad
tetras63017623tetras
tetri52716453te_tri
tetryl935693tetryl
tets45847463te_t_s
tetter64322453tetter
texas126514933te_xas
text116033933text__
textile1437223textile
texts125515043text_s
textural1544943textural
theca103311453thec_a_
thecae11299653thec_ae
thecate123210023thecate
thenal92712433thenal
thermal125010973thermal
theta83414573theta_
thetas93011573thetas
tibial849843tibial
ticals83214713tic_als
tictacs1145793tictacs
tictoc1036003tictoc
tidal64516453t_idal
timbal102510753timbal
tincal83913373tincal
tineal66216173tineal
titan53318173t_itan
toecap1037323toec_ap
tombal102311023tombal
tonal53724303t_onal
torta55925353torta_
tortas64918253tortas
totals63115163t_otals
trial54926353t_rial
tribal8611133tribal
trinal6516963trinal
trochal1288243trochal
trotyl9236673trotyl
tubal75517203t_ubal
tussal6288323tussal
tymbal13236823tymbal
typal105311153t_ypal
uncial83715223uncial
veal76936813ve__al
vector113212063vector
vegetal1156303vegetal
veinal93812963veinal
venal85523213ve_nal
venial94218283venial
ventail10310453ventail
ventral103612173ventral
verbal112513663verbal
vernal93514213vernal
versal93013753versal
vesta86618303vesta_
vestals104612333vestals
vestas95916683vestas
vestral104111013vestral
victual1246253victual
vital84819673_vital
vocal104715643voc_al
weal75838683we__al
xenial133414903xenial
yenta83917043yenta_
yentas94614213yentas
zeal135530333ze__al
zeta135121643ze_ta_
zetas145018163ze_tas

Search took 10 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.796224486.2
2DLD Change Limit1127164488.07613956.9
3Display Results4484480.1602800.0
 (SQL Overall)1786914489.03219784.2
 
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.