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

133 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
chastely163581(None) 
chantey154112542chante_y
chaste114617392chaste__
chasten124312402chaste_n
chastens13429182chastens
chaster124718502chaste_r
chastest1349702chastest
chastity1645272chastity
chattel12388892chattel_
chattels13286792chattels
chattery16357272chattery
chattily1634602chattily
chestily1645522chestily
ghastly14354562ghast_ly
hastily133010662_hastily
unchastely1852722unchastely
basely114412313_bas_ely
beastly1277563beast_ly
cartel85022533c_artel_
cartels94618123c_artels
casefy1436273c_as_efy
caste75932363c_aste__
caster85232573c_aste_r
casters94729903c_asters
castes85631863c_aste_s
castle84918963c_ast_le
castled104311513c_astled
castles94917733c_astles
cattery123811603c_attery
cattily123210853c_attily
cautery12349593c_autery
chaetal1238283chaetal_
chally144314293cha__lly
chancel144011773chancel_
chancels15439083chancels
chancery18366653chancery
chancily1845243chancily
channel123910483channel_
channels13388493channels
chanted134015953chante_d
chanter123919733chante_r
chanters134016743chanters
chanteys16387493chanteys
chantry15388223chant_ry
chanty145215823chant__y
chapel134911373cha_pel_
chapels14429153cha_pels
chapter144213853chapte_r
chapters154012133chapters
charily15310283cha_rily
charley15118273charle_y
charnel124010053charnel_
charnels13328173charnels
charted135116853charte_d
charter123918303charte_r
charters134115583charters
chase105127123chas_e__
chased125019293chas_e_d
chaser114918383chas_e_r
chasers123714923chas_ers
chases115128233chas_e_s
chasmal14158213chasmal_
chasmed154710173chasme_d
chasmy16468543chas__my
chasse115114603chasse__
chassed134712133chasse_d
chasses124017503chasse_s
chasseur1343443chasseur
chastened1545883chastened
chastener1445703chastener
chastise1348173chastise
chasuble1543063chasuble
chateau1236273cha_teau
chatted133411893chatte_d
chatter124416643chatte_r
chatters134213953chatters
chatty14419363cha_t_ty
chested133811673cheste_d
chesty144610503chest__y
chisel112111943chis_el_
chisels12219103chis_els
choicely1843823choicely
classily1336623classily
clattery13378193clattery
clavately1742613clavately
closely1237053clos_ely
clustery13317113clustery
coarsely1335533coarsely
coastal9411043coastal_
coastally1446493coastally
coasted104015953coaste_d
coaster94219043coaste_r
coasters104317333coasters
costly114012333c_ost_ly
craftily1644783craftily
crassly1276653cras_sly
crustily13328173crustily
cutely115312803c__utely
easterly11246643_easterly
ghostly14355103ghost_ly
hassel95614213_hassel_
hassels104311013_hassels
hastately1543603_hastately
haste85927863_haste__
hasted105125283_haste_d
hasten95718563_haste_n
hastens106214813_hastens
hastes95727073_haste_s
hasty115718763_hast__y
hostel93914153_hostel_
hostelry1443913_hostelry
hostels103712313_hostels
hostly124210863_host_ly
irately1047683ira_tely
lastly93310873_last_ly
lately93413843_la_tely
masterly13317653_masterly
mastery124214323_mastery
nastily103011033_nastily
ovately1334433ova_tely
pastel85918713_pastel_
pastels95215183_pastels
plastery13279703plastery
shantey134210043shante_y
shapely1536893sha_pely
stately10310223sta_tely
tastily103311643_tastily
thistly1395963thist_ly
vastly12508723_vast_ly
wastery134610993_wastery
weasely13317853weas_ely
whitely16346473wh_itely
yeastily1444573yeastily

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621337.97018339.0
3Display Results1331330.0462891.3
 (SQL Overall)1786911338.17221866.3
 
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.