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

420 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
chasten12431240(None) 
chaste114617391chaste_
chastens13429181chastens
chaster124718501chaster
hasten95718561_hasten
caste75932362c_aste_
caster85232572c_aster
castes85631862c_astes
chanted134015952chanted
chanter123919732chanter
chantey154112542chantey
chapmen1637282chapmen
chapter144213852chapter
charted135116852charted
charter123918302charter
chase105127122chas_e_
chased125019292chas_ed
chaser114918382chas_er
chases115128232chas_es
chasmed154710172chasmed
chasse115114602chasse_
chassed134712132chassed
chasses124017502chasses
chastely1635812chastely
chastened1545882chastened
chastener1445702chastener
chastest1349702chastest
chatted133411892chatted
chattel12388892chattel
chatter124416642chatter
chazzen20214782chazzen
chested133811672chested
chorten122811302chorten
chosen116014132chos_en
christen13106702christen
coasted104015942coasted
coaster94219032coaster
fasten95114892_fasten
hapten115312982_hapten
haste85927862_haste_
hasted105125282_hasted
hastens106214812_hastens
hastes95727072_hastes
ashen87818673__ashen
aspen75216093__aspen
aster55434893__aster
astern64815813__astern
baste74829983_baste_
basted95227233_basted
baster85333593_baster
bastes85330383_bastes
batten85217123_batten
beaten84617063bea_ten
blasted104213473blasted
blaster94017303blaster
boasted104113743boasted
boaster94616433boaster
cabmen123610653c_abmen
cadaster1136893cadaster
caftan111710123c_aftan
canted94825783c_anted
canteen9411083c_anteen
canter85230113c_anter
canton85722993c_anton
capstan1137903capstan
captan101613343c_aptan
careen84119493c_areen
carmen104019343c_armen
carte75940423c_arte_
carted98631443c_arted
cartel85022533c_artel
carter84932273c_arter
cartes86239473c_artes
carton84522663c_arton
carven114716663c_arven
case65848083c_as_e_
cased86032413c_as_ed
casein83216453c_asein
casern84713313c_asern
cases75048383c_as_es
cashed125124353c_ashed
cashes114729883c_ashes
cashew144311453c_ashew
casked134815513c_asked
casket124820993c_asket
cassena9287843c_assena
cassene93111543c_assene
cast67159903c_ast__
casters94729893c_asters
casting104628343c_asting
castle84918963c_astle
castled104311513c_astled
castles94917733c_astles
castor84418533c_astor
casts77237793c_ast_s
cate66254593c_a_te_
catena8312473c_a_tena
cater74840703c_a_ter
cates75951873c_a_tes
catted95422473c_atted
cease75227653ceas_e_
ceased94920783ceas_ed
ceases84427073ceas_es
cerastes101111093cerastes
chaeta11310683chaet_a
chaetae1238603chaetae
chaetal1238283chaetal
chafe135117353cha_fe_
chafed154813913cha_fed
chafer144714573cha_fer
chafes145017913cha_fes
chaffed19387703chaffed
chaffer18389473chaffer
chagrin1337883chagrin
chain105723673cha__in
chaine115119223chaine_
chained133812693chained
chaines124518733chaines
chainmen15105263chainmen
chaired134211243chaired
chairmen15105473chairmen
chaise114916413chaise_
chaises124317493chaises
chaleh143711993cha_leh
chalet113825993cha_let
chalets122813473chalets
chalked17449863chalked
chalone12312103chalone
chamber164011053chamber
chamfer17399853chamfer
champed174111473champed
champer163813403champer
chance134617093chance_
chanced154113213chanced
chancel144011773chancel
chancer144215633chancer
chances145218093chances
change124116753change_
changed144214143changed
changer134215543changer
changes134517583changes
channel123910483channel
chanson1238043chanson
chant105932693chant__
chanters134016723chanters
chanteys16387493chanteys
chanties132615803chanties
chanting143413533chanting
chantor123710313chantor
chantry15388213chantry
chants115020393chant_s
chanty145215823chant_y
chaoses124715113chaoses
chaotic14310013chaotic
chape125221143cha_pe_
chapel134911373cha_pel
chapes135421873cha_pes
chapiter1536603chapiter
chaplet14512253chaplet
chapman1637893chapman
chapped172711443chapped
chapt125827643chapt__
chapters154012113chapters
chare105231983cha_re_
chared125423693cha_red
chares115631803cha_res
charge125114213charge_
charged144614023charged
charger133914063charger
charges134615983charges
charier124317903charier
charked174814013charked
charley15118273charley
charmed154714243charmed
charmer144913663charmer
charnel124010053charnel
charred134614483charred
chart105038283chart__
charters134115563charters
charting142614193charting
charts115823093chart_s
chasers123714893chasers
chasing133715893chasing
chasm125518793chas__m
chasmal14158213chasmal
chasmic16177983chasmic
chasms135513143chas_ms
chasmy16468543chas_my
chasseing1554963chasseing
chasseur1343433chasseur
chassis123910663chassis
chasteners1554793chasteners
chasteness1546523chasteness
chastening1656523chastening
chastise1348173chastise
chastised1554683chastised
chastiser1444373chastiser
chastises1437703chastises
chastity1645273chastity
chat95546133cha_t__
chateau1236263cha_teau
chats105730093cha_t_s
chattels13286793chattels
chatters134213933chatters
chattery16357273chattery
chattier1337513chattier
chatting142810143chatting
chatty14419363cha_tty
chaufer15347943chaufer
chaunted1485603chaunted
chaunter1366383chaunter
chausses1345963chausses
chawed155214603cha_wed
chawer144314413cha_wer
chayote1536493chayote_
chayotes1636493chayotes
chazan20269133cha_zan
chazzan20204853chazzan
chazzens21253943chazzens
cheapen14407623cheapen
cheated134416343cheated
cheater124816953cheater
chesses124112633chesses
chessmen1544463chessmen
chest104926143chest__
chestier1387423chestier
chests114916263chest_s
chesty144610503chest_y
chiastic15287473chiastic
chicken18278983chicken
chidden14255223chidden
chirren12388743chirren
chisel112111943chis_el
chitin113114953ch_itin
chiton112612393ch_iton
chitter124112963chitter
chortens13308793chortens
chose105925403chos_e_
choses115825123chos_es
christens14125413christens
chunter123911473chunter
chute104316463ch_ute_
chuted124611843ch_uted
chutes114615763ch_utes
cisted95217523c_isted
cistern93310693c_istern
clansmen1245723clansmen
clashed133614013clashed
clasher124615513clasher
clashes124017283clashes
clasped123610443clasped
clasper113811863clasper
classed104113653classed
classer93614613classer
classes94717943classes
classon937693classon
clast76030583clast__
clastic113013953clastic
clasts84817293clast_s
clatter94014973clatter
cluster94013323cluster
clyster12317453clyster
coacted123611603coacted
coapted123911493coapted
coarsen93210323coarsen
coast75236263coast__
coastal9411033coastal
coasters104317303coasters
coasting113615503coasting
coasts85719133coast_s
coated94927033coa_ted
coatee84327213coa_tee
coater84329553coa_ter
coattend1134643coattend
cohosted1436133cohosted
costed95623113c_osted
coster84331293c_oster
crafted13419773crafted
crafter124111333crafter
cragsmen1344763cragsmen
crases85532313cras_es
crashed134214203crashed
crasher124616153crasher
crashes124618403crashes
crasser94114333crasser
crate76537403cra_te_
crated94827773cra_ted
crater85026633cra_ter
crates85736053cra_tes
craton84517193cra_ton
craven114113933cra_ven
crested103416533crested
crispen11348203crispen
crusted103712753crusted
cystein1246053c_ystein
cytaster1383863cytaster
diastem10318043diastem
diaster82813313diaster
easter65027983_easter
eastern74412533_eastern
eaten55323053_ea_ten
elastin72611843elastin
fasted105320953_fasted
fastens105511753_fastens
faster94625773_faster
fatten94314903_fatten
feasted11310843feasted
feaster10812983feaster
flatten10429653flatten
gasmen93111563_gasmen
gasted84821583_gasted
gaster75027353_gaster
ghast95621223ghast__
ghastly14354563ghastly
ghosted1236273ghosted
glisten8418083glisten
haen76229453_ha__en
hafted134713833_hafted
hafter124815883_hafter
halted105019603_halted
halter94420883_halter
hamster12810423_hamster
hanted104124313_hanted
happen134812193_happen
haptene123810933_haptene
haptens124511343_haptens
harden105718533_harden
harken135116343_harken
harshen1339283_harshen
hashed136021943_hashed
hashes125024803_hashes
haslet93222713_haslet
hasped125014443_hasped
hassel95614213_hassel
hast76259483_hast__
hastened12239103_hastened
hastener11259133_hastener
hastier103916623_hastier
hasting114725193_hasting
hasty115718763_hast_y
hate78450173_ha_te_
hated95734023_ha_ted
hater85034753_ha_ter
hates86742573_ha_tes
hatted104921513_hatted
hatter94724873_hatter
hausen9610383_hausen
haute89521613_haute_
haven114718533_ha_ven
hearten102411753hearten
histed104420243_histed
hosen85623883_hos_en
hosted105020343_hosted
hostel93914153_hostel
khamseen1741813khamseen
khazen2233773kha_zen
lasted74323603_lasted
laster64830633_laster
laten54328343_la_ten
latten65018203_latten
listen64816813_listen
marten84518263_marten
masted94025803_masted
master84831343_master
moisten93110143moisten
neaten64214543nea_ten
oaten55222403_oa_ten
paste74932953_paste_
pasted94426903_pasted
pastel85918713_pastel
paster85734373_paster
pastern94415063_pastern
pastes85233913_pastes
paten74827343_pa_ten
patten84418193_patten
peasen84815963peas_en
phaeton1235973phaeton
phase104617213phas_e_
phased124011973phas_ed
phases114618403phas_es
phatter123810203phatter
piaster93012883piaster
plaster93318693plaster
platen84518203pla_ten
raster64731443_raster
ratten64217383_ratten
refasten1136103refasten
roasted83912663roasted
roaster74116663roaster
shafted14288803shafted
shaitan1036883shaitan
shaken134113613sha_ken
shantey134210033shantey
shapen114414653sha_pen
sharpen12389723sharpen
shatter103615693shatter
shaven124213303sha_ven
shorten103511403shorten
shotten10288443shotten
shyster13116553shyster
smarten9348863smarten
taste55127233_taste_
tasted74123973_tasted
taster64930573_taster
tastes64126423_tastes
tauten64311893_tauten
toasted84011923toasted
toaster74414463toaster
unchaste1346923unchaste_
unchaster1445393unchaster
unfasten1144843unfasten
vaster94521023_vaster
waste86125053_waste_
wasted104423023_wasted
waster95228943_waster
wastes96224883_wastes
wheaten1336403wheaten
whisted144010013whisted
whiten124111923wh_iten
yeasted1138503yeasted

Search took 8 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.1531167915.0
2DLD Change Limit1340274206.81319672.2
3Display Results4204200.1432937.1
 (SQL Overall)1786914207.10925135.9
 
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.