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

113 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
crescent1271105(None) 
crescents1367541crescents
acescent1248012acescent
calescent13118222calescent
canescent13118762canescent
credent10313972cre_dent
crescendi1442872crescendi
crescendo1442752crescendo
crescentic1353452crescentic
cresset93319942cresse_t
decrescent1545642decrescent
descent102616292_descent
excrescent2154612excrescent
increscent1446652increscent
precent113520262pre_cent
prescient13411322prescient
present94022732pres_ent
reascent10411982_reascent
recent83630852_re_cent
resent63833622_res_ent
virescent1445882virescent
acescents1345233acescents
albescent1345463albescent
ascent84519653__ascent
candescent1556293candescent
casement12311953casement
cement103321673c_e_ment
cerement12315133cerement
clement11313773cle_ment
coalescent1496653coalescent
concent114422513c_oncent
concrescent1455473concrescent
consent93723113cons_ent
copresent1349923copres_ent
coresident1376793coresident
coruscant13246043coruscant
cosecant12410683cosecant
crassest103411523crassest
creasiest11229943creasiest
creodont1147693creodont
crepiest12310383crepiest
crescendos1552043crescendos
crescive1545283crescive
cresses94219813cresse_s
cressets10309103cressets
crest74632693cres___t
crested103416553creste_d
cresting114017043cresting
crewcut1445023crewc_ut
crewmen1436383crewmen_
crispen11348203crispen_
crispens12286253crispens
crispest12177373crispest
crossest1012012123crossest
cruset84425093crus_e_t
decent94023703_de_cent
descant104315593_descant
descend11248153_descend
descents112511203_descents
florescent1545673florescent
frequent2046423frequent
freshen133010883freshen_
freshens14298313freshens
freshest143010583freshest
freshet133416643freshe_t
frutescent1553563frutescent
ignescent1245203ignescent
iridescent1354293iridescent
nascent9610523_nascent
nescient1048713_nescient
percent113520603_percent
precents123015043pre_cents
precept133112513pre_cept
prescind1338393prescind
presents103315643pres_ents
preset84430983pres_e_t
president12410993president
prevent124016553pre_vent
pubescent1545443pubescent
putrescent1465213putrescent
quiescent2055703quiescent
reaccent1278573_reaccent
reagent8716603_reagent
reascend1145703_reascend
reascents1177403_reascents
reblent9614253_reblent
recant83228683_re_cant
recept103319083_re_cept
regent74127673_re_gent
relent64431853_re_lent
relucent1049283_relucent
renascent1147483_renascent
repent84728873_re_pent
rerent63832453_re_rent
rescind10410393_rescind
reseat64131493_res_eat
resect84424703_res_ect
reseen64318413_reseen_
resend75016773_res_end
resents74221223_res_ents
reset55051863_res_e_t
resident9313753_resident
resmelt9411773_resmelt
respect11412033_respect
respelt9312143_respelt
reticent10313293_reticent
rubescent1345833rubescent
rufescent1444863rufescent
scent75831623___scent
senescent1167793senescent
trecento1066213tre_cento
tumescent1345413tumescent
turgescent1353483turgescent

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.406440125.6
2DLD Change Limit1461621136.97020970.2
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.42224075.9
 
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.