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

215 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
chastest134970(None) 
castes85631862c_astes_
chariest13315502chariest
chartist131112132chartist
chases115128232chas_es_
chasses124017502chasses_
chaste114617392chaste__
chastely1635812chastely
chasten124312402chaste_n
chastens13429182chastens
chaster124718502chaste_r
chastise1348172chastise
chattiest1448202chattiest
chestiest1438312chestiest
coattest1038852coattest
crassest103411522crassest
fastest102413722_fastest
hastes95727072_hastes_
hastiest112916492_hastiest
phattest1336912phattest
unchastest1543422unchastest
vastest102911512_vastest
aptest82917513__aptest
attest62618613__attest
basest84720493_bas_est
bastes85330383_bastes_
blastiest111710043blastiest
brashest133511763brashest
cagiest102916433c_agiest
cakiest133215663c_akiest
calmest11312343c_almest
cartes86239473c_artes_
cases75048383c_as_es_
cashes114729883c_ashes_
casket124820993c_aske_t
caskets133910173c_askets
caste75932363c_aste__
casteism1247073c_asteism
caster85232573c_aste_r
casters94729893c_asters
castles94917733c_astles_
casts77237793c_ast_s_
casuist9411303c_asuist
cates75951873c_a_tes_
cattiest103016333c_attiest
ceases84427073ceas_es_
cerastes101111093cerastes_
chadless1436403chadless
chafes145017913cha_fes_
chaffiest2045403chaffiest
chaines124518733chaines_
chaises124317493chaises_
chalet113825993cha_le_t
chalets122813473chalets_
chalkiest1837083chalkiest
chances145218093chances_
chanciest1638373chanciest
changes134517583changes_
chanted134015953chante_d
chanter123919733chante_r
chanters134016723chanters
chanteuse1443473chanteuse
chantey154112543chante_y
chanteys16387493chanteys
chanties132615803chanties_
chants115020393chant_s_
chaoses124715113chaoses_
chapes135421873cha_pes_
chaplet14512253chaple_t
chaplets1556883chaplets
chapter144213853chapte_r
chapters154012113chapters
chares115631803cha_res_
charges134615983charges_
charriest1438253charriest
charted135116853charte_d
charter123918303charte_r
charters134115563charters
chartists14126803chartists
chartless1435703chartless
charts115823093chart_s_
chase105127123chas_e__
chased125019293chas_e_d
chaser114918383chas_e_r
chasers123714893chas_ers
chasmed154710173chasme_d
chasms135513143chas_ms_
chasse115114603chas__se
chassed134712133chasse_d
chassepot1652503chassepot
chasseur1343433chasseur
chassis123910663chassis_
chastened1545883chastened
chastener1445703chastener
chasteness1546523chasteness
chastised1554683chastised
chastiser1444373chastiser
chastises1437703chastises
chastity1645273chastity
chateau1236263cha_teau
chats105730093cha_t_s_
chatted133411893chatte_d
chattel12388893chatte_l
chattels13286793chattels
chatter124416643chatte_r
chatters134213933chatters
chattery16357273chattery
chausses1345963chausses_
chayotes1636493chayotes_
cheapest1536073cheapest
cheesiest1436323cheesiest
chertiest1438793chertiest
chesses124112633chesses_
chest104926143ch___est
chested133811673cheste_d
chestnut1344433chestnut
chests114916263chest_s_
chewiest16177293chewiest
chicest14209943ch_icest
chiefest1645313chiefest
chillest13259593chillest
chirkest1735383chirkest
choicest15226453choicest
chokiest1738723chokiest
choosiest1437323choosiest
choses115825123chos_es_
chuffest1944183chuffest
chutes114615763ch_utes_
chutist1239453ch_utist
clashes124017283clashes_
classes94717943classes_
classiest11309543classiest
classist104010383classist
clasts84817293clast_s_
clayiest1337913clayiest
closest94312533clos_est
coaliest10316223coaliest
coarsest1039163coarsest
coassist10298803coassist
coasted104015943coaste_d
coaster94219033coaste_r
coasters104317303coasters
coasts85719133coast_s_
coattests1143453coattests
cohostess1443433cohostess
contest93523233c_ontest
cosiest93819853c_osiest
craftiest1436913craftiest
crankest1438143crankest
crases85532313cras_es_
crashes124618403crashes_
crates85736053cra_tes_
craziest19319923craziest
creasiest11229943creasiest
crispest12177373crispest
crossest1012012123crossest
crustiest112410043crustiest
curtest9713963c_urtest
cutest85820143c__utest
daftest11248943_daftest
easiest72318773_easiest
exactest1745453exactest
fattest102913063_fattest
featest102715113fea_test
flattest1138713flattest
gashest114813413_gashest
ghastliest1443443ghastliest
ghostiest1336543ghostiest
haddest122711993_haddest
halest94823273_ha_lest
hardest113118413_hardest
harshest14310193_harshest
harvest132112753_harvest
hashes125024803_hashes_
haslet93222713_hasle_t
haslets102510863_haslets
haste85927863_haste__
hasted105125283_haste_d
hasten95718563_haste_n
hastens106214813_hastens
hates86742573_ha_tes_
haziest193313003_haziest
hostess103210233_hostess
hottest10411383_hottest
iratest7312483ira_test
justest1449893_justest
latest63822703_la_test
moistest1038763moistest
mostest9314793_mostest
nastiest83615953_nastiest
neatest72516003nea_test
pastes85233913_pastes_
pastiest103319543_pastiest
peartest10311293peartest
phantast1346923phantast
phases114618403phas_es_
rashest103916873_rashest
saltest71916513_saltest
scantest101710183scantest
shadiest121711273shadiest
shakiest151910933shakiest
shaliest111415043shaliest
sharpest1339143sharpest
shortest11310773shortest
smartest10310183smartest
tartest72517533_tartest
tastes64126423_tastes_
tastiest83216633_tastiest
tautest72612443_tautest
toastiest937423toastiest
vastiest112713073_vastiest
wastes96224883_wastes_
wattest102412153_wattest
whitest133710113wh_itest
yeastiest1237203yeastiest

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622157.29620033.2
3Display Results2152150.0762828.9
 (SQL Overall)1786912157.54523683.4
 
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.