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

197 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
chaetal123828(None) 
chaeta11310681chaeta_
chaetae1238601chaetae
caecal103713732c_aecal
cantal84122032c_antal
chaebol1444942chaebol
chasmal14158212chasmal
chateau1236272chateau
chattel12388892chattel
cheetah1545452cheetah
chetah14399582ch_etah
chital114313882ch_ital
coaeval1245182coaeval
coastal9411042coastal
haemal113811652_haemal
hartal9415482_hartal
hyetal1236542_hyetal
acetal84314903_acetal
archaeal13115463archae_al
artal55525483__artal
bhakta1533653bhakta_
bhaktas1633643bhaktas
bharal1138893bha_ral
bimetal1138433bimetal
cabal95222153c_a_bal
caeca93915133c_aeca_
caesar8410943c_aesar
caftan111710123c_aftan
cameral11311283cameral
canal75428043c_a_nal
cantala94114673c_antala
cantals93919573c_antals
canthal12410053c_anthal
capital112311523capital
captan101613343c_aptan
carnal83919223c_arnal
carpal103716263c_arpal
cartel85022533c_artel
casual81112873c_asual
catalo8314853c_a_talo
cattail939183c_attail
cattalo938423c_attalo
caudal91611483c_audal
causal81413203c_ausal
cecal94619113c__ecal
cental84420963c_ental
cereal8315833cere_al
chacma1537903chacma_
chacmas1638003chacmas
chadar1239353cha_dar
chaebols1544723chaebols
chakra15437533chakra_
chakras16428503chakras
chalah143511663cha_lah
chalazal2243873chalazal
chalet113825993chalet__
chalets122813473chalet_s
challa114014193challa_
challah15458323challah
challas124414123challas
champac1834953champac
champak2034493champak
chancel144011783chancel
channel123910493channel
chant105932693chant__
chantable1636893chantable
chantage1446633chantage
chanted134015953chanted
chanter123919733chanter
chantey154112543chantey
chantor123710313chantor
chantry15388223chantry
chants115020393chant_s
chanty145215823chant_y
chaotic14310043chaotic
chapati14118023chapati
chapeau1435523chapeau
chapel134911373cha_pel
chapman1637893chapman
chapt125827643chapt__
chapter144213853chapter
chapteral1644703chapteral
chaqueta2242753chaqueta_
chaquetas2342193chaquetas
charas114223613cha_ras
charcoal15165743charcoal
charka154011703charka_
charkas164810963charkas
charnel124010053charnel
charpai1436633charpai
chart105038283chart__
chartable1636833chartable
charted135116853charted
charter123918303charter
charts115823093chart_s
chaste114617393chast_e
chastely1635813chastely
chasten124312403chasten
chaster124718503chaster
chat95546133cha_t__
chateaus1346013chateaus
chateaux2043073chateaux
chats105730093cha_t_s
chatted133411893chatted
chattels13286793chattels
chatter124416643chatter
chattily1634603chattily
chatty14419363cha_tty
chazan20269133cha_zan
chazzan20204853chazzan
cheap126915943ch_e_ap
cheat105732453ch_e_at
cheatable1646713cheatable
cheated134416353cheated
cheater124816963cheater
cheats114519543cheat_s
cheetahs1643783cheetahs
chela103916803ch_ela_
chelae113614613ch_elae
chelas113817203ch_elas
chetahs15347073ch_etahs
cheth135013823ch_et_h
cheths14389823ch_eths
chiasmal15285033chiasmal
chiel104918973chie__l
chigetai1443233chigetai
chiral114614413ch_iral
chloral12169983chloral
choral115118493ch_oral
chordal13449883chordal
choreal124412223choreal
chorial124214143chorial
clausal936273clausal
cliental1045363cliental
coaevals1344563coaevals
coattail1045313coattail
coaxal15387303coa_xal
coaxial16157003coaxial
coeval1138893c_oeval
coital84117053c_oital
costal85419513c_ostal
craal74117753cra__al
cranial92114683cranial
credal9311673c_redal
creedal1037093creedal
crestal9312133crestal
crustal939023crustal
cryptal1445683cryptal
crystal1237433crystal
cubital1137103cubital
cuneal8611513cune_al
curtal83914543c_urtal
daedal849083_daedal
faecal11359813_faecal
fatal84819373_fa_tal
fetal85623373__fetal
foetal9311883_foetal
fractal1237623fractal
gametal1037603gametal
gharial1137343gharial
hadal95518123_ha_dal
haematal1345143_haematal
haet75659503_haet__
haets86525123_haet_s
halal85623593_ha_lal
hallal94415563_hallal
hamal104623123_ha_mal
hammal134512073_hammal
hartals10313023_hartals
heal75645693_h_e_al
hemal104419803_h_emal
hiatal9310203_hiatal
hiemal11339513_hiemal
meatal84114733mea_tal
metal75427383__metal
natal53921493_na_tal
octantal1044563octantal
petal76526893__petal
phaeton1235973phaeton
phaseal1245673phaseal
quantal16367893quantal
ratal55025113_ra_tal
segetal868383segetal
setal56430903__setal
shaitan1036893shaitan
shavetail1552403shavetail
sheal84927703sh_e_al
shtetel1033943shtetel
shtetl936443shtet_l
statal61613223sta_tal
tapetal938273tapetal
thecal113310313th_ecal
thenal92712433th_enal
theta83414573th_eta_
thetas93011573th_etas
vegetal1156303vegetal
wheal115716183wh_e_al

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.440406115.9
2DLD Change Limit1340271977.53017799.1
3Display Results1971970.0633127.0
 (SQL Overall)1786911978.03322244.6
 
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.