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

335 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
thecal11331030(None) 
theca103311451theca_
thecae11299651thecae
thenal92712421thenal
caecal103713732caecal
cecal94619112_cecal
decal85523232_decal
ethical1238442ethical
faecal11359812faecal
fecal105119212_fecal
heal75645692_he_al
hemal104419802_hemal
oothecal1343912oothecal
sheal84927702she_al
teal45546502t_e_al
tectal83713252t_ectal
tepal76319582t_epal
thecate123210022thecate
thenar92610002thenar
thermal125010972thermal
theta83414572theta_
thetas93011572thetas
thetical1349122thetical
tical76021492t_ical
tincal83913362tincal
toecap1037322toecap
wheal115716182whe_al
acetal84314903acetal
aecial84817313_aecial
ahead96817053ahe_ad
antheral1149393antheral
apical10913903apical
areal55928733are_al
areca75618633areca_
arecas84817443arecas
becalm1239203_becalm
becap114315053_becap
bharal1138893bharal
buccal1248243buccal
caeca93915133caeca_
ceca84820783_ceca_
cercal10314123cercal
chaetal1238283chaetal
cheap126915943che_ap
cheat105732453che_at
check164714713chec_k
checks174912703checks
chela103916803chela_
chelae113614603chelae
chelas113817203chelas
chemical1748393chemical
chetah14399583chetah
chica125818263chica_
chicas135916473chicas
chiral114614413chiral
chital114313883chital
choral115118493choral
coccal9310223coccal
coeval1138893coeval
credal9311673credal
daedal849083daedal
deal56347413_de_al
decaf114919443_decaf
decals93717713_decals
decay114718483_decay
dedal75719023_dedal
dhal86719283dh__al
ducal84816423_ducal
egal55119433__egal
epical10413393epical
ethereal1146783ethereal
ethicals1345533ethicals
ethnical1346363ethnical
faucal11339963faucal
feal713940423_fe_al
fecial114714623_fecial
feral85424653_feral
fetal85623373_fetal
fiscal1139333fiscal
focal104917673_focal
foetal9311883foetal
gherao1036753gherao
hadal95518123_hadal
haemal113811643haemal
halal85623593_halal
hamal104623113_hamal
head87137173_he_ad
heals85733453_he_als
heap96432893_he_ap
hear76143883_he_ar
heat77061423_he_at
heck135826493_hec_k
heckle153112093_heckle
hecks145220653_hecks
heel75034223_he_el
heil76328933_he_il
helical12311153_helical
hell75637893_he_ll
hepcat13611823_hepcat
herald10311343_herald
herbal112513493_herbal
herl75834553_he_rl
hexad164910623_hexad
hexyl1844463_hexyl
hiemal11339503hiemal
horal86328683_horal
hyetal1236543hyetal
icecap1245223icecap
ideal65716393ide_al
ileal56118083ile_al
ipecac1264623ipecac
jacal14313703_jacal
kheda1346533kheda_
khedah1743643khedah
khedas1446313khedas
laical8312323laical
leal46043273_le_al
legal65715943_legal
lienal63912783lienal
local74820273_local
meal65643173_me_al
medal86221333_medal
mescal104113483mescal
metal75427383_metal
mezcal19367853mezcal
mythical1845033mythical
ootheca1244003ootheca_
oothecae1343713oothecae
pascal10812373pascal
peal68648103_pe_al
pecan91919033_pecan
pedal86022503_pedal
penal75228373_penal
petal76526893_petal
phenol1149253phenol
phenyl1435323phenyl
phial10313203ph_ial
phonal11310383phonal
pical95524373_pical
plexal1536833plexal
plical10411683plical
quezal2435143quezal
rascal8511123rascal
real45750293_re_al
recall83815723_recall
recap95718023_recap
recoal84117973_recoal
rectal84418133_rectal
regal65023793_regal
renal55929503_renal
rhea75017433rhe_a_
rheas84816953rhe_as
rhinal9510193rhinal
seal45654373_se_al
sepal77723003_sepal
seral56336383_seral
setal56430903_setal
shea76031573she_a_
sheaf115424123she_af
sheals94420643she_als
shear85424833she_ar
sheas86331793she_as
sheila969843sheila
shekel1338383shekel
shell84424123she_ll
sheol84318373she_ol
sheqel1846523sheqel
shoal83920273sh_oal
special11310303special
spheral1238423spheral
steal56125473ste_al
stoical9310283stoical
sulcal8311273sulcal
tael46030713tae__l
tamal73522623t_amal
tapetal938273tapetal
tarnal63716503tarnal
tarsal63315273tarsal
tea37353323t_e_a_
teach105221123t_each
teak85930843t_e_ak
teals56234133t_e_als
team66238653t_e_am
tear45242883t_e_ar
teas45851493t_e_as
teat45963633t_e_at
tech95925443t_ec_h
techs106915833t_echs
techy135612013t_echy
tecta74215523t_ecta
teel46335803t_e_el
tel35647903t_e__l
tela45532973t_ela_
telae54323293t_elae
telial65815363telial
tell44934703t_e_ll
tenail64516113t_enail
tepa66021683t_epa_
tepals85415043t_epals
tepas76521683t_epas
terai53525483t_erai
tercel83612993tercel
tergal72912833tergal
tesla55612603t_esla
texas126514933t_exas
thack144915173thac_k
thacks154311923thacks
thae76825563th__ae
than76128773th__an
that75639323th__at
thaw107521313th__aw
the67436053the___
thebe107515433the_be
thebes115914493thebes
thee78039063the__e
theelol1044273theelol
theft114118133the_ft
thefts12387923thefts
thegn95810903the_gn
thegnly1442613thegnly
thegns10547433thegns
thein85919023the_in
theine94814923theine
theins95015423theins
their85512153the_ir
theirs94610353theirs
theism1139483theism
theist9314763theist
them97427043the__m
theme105921733the_me
themed125912583themed
themes115319253themes
then78429693the__n
thenage11107843thenage
thenars10248523thenars
thence112010843thence
thens85921833the_ns
theocrat1346353theocrat
theory121098363theory
therapy1536613therapy
there87527393the_re
thereat104315243thereat
theres96525473theres
theriac1239143theriac
theriacal1443553theriacal
therian10311293therian
therm106018023the_rm
thermae125310503thermae
thermals13518533thermals
therme115814993therme
thermel12569893thermel
therms115914873therms
these86519013the_se
theses96517973theses
thesis94913733thesis
thesp105410313the_sp
thesps11448263thesps
thetic11412893thetic
thew108226233the__w
thews117416193the_ws
thewy146311853the_wy
they107223753the__y
thick145613353thic_k
thickly19415573thickly
thicks154511993thicks
thill85918733th_ill
thiol87616043th_iol
thiram1139963thiram
thirl85416823th_irl
thoracal1344913thoracal
thorax1638253thorax
thrall93810293thrall
thraw1110515923th_raw
thread105011093thread
threap11569663threap
threat95020463threat
thrill94910593thrill
throat94819753throat
thuja1535213thuja_
thujas1634433thujas
thurl84912683th_url
thuya1135583thuya_
thuyas1234773thuyas
thwack1834213thwack
thymol1434463thymol
tibial849843tibial
ticals83214713t_icals
tidal64516443t_idal
tiercel9316203tiercel
timbal102510753timbal
tincals93610643tincals
tineal66216163tineal
tipcat10312653tipcat
toea46732333toe_a_
toeas55726423toe_as
toecaps1135553toecaps
toenail738783toenail
tombal102311023tombal
tomcat101013453tomcat
tonal53724303t_onal
topical1139953topical
total55321823t_otal
toucan838193toucan
toxical1637643toxical
treacle939973treacle
treacly1237093treacly
tread64821703tre_ad
treat56240353tre_at
trefah1235093trefah
trehala1045953trehala
trenail7410813trenail
trepan82511673trepan
trial54926353t_rial
tribal8611133tribal
trinal6516963trinal
trocar848773trocar
trochal1288243trochal
tubal75517203t_ubal
tussal6288323tussal
tweak1257753twe_ak
tymbal13236823tymbal
typal105311153t_ypal
typical1436343typical
ureal56722683ure_al
uveal84411073uve_al
veal76936813_ve_al
venal85523213_venal
vocal104715643_vocal
weal75838683_we_al
wheals124512523whe_als
wheat114924573whe_at
wheel115515333whe_el
whenas124610463whenas
zeal135530333_ze_al
zoeal144813783zoe_al

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.1401276364.3
2DLD Change Limit1127163355.90619085.0
3Display Results3353350.0933602.2
 (SQL Overall)1786913356.13929107.5
 
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.