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

187 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
secreting127982(None) 
secretin10108341secretin_
secretins11108461secretins
accreting1446332accreting
decreeing1335522decreeing
excreting1946432excreting
ferreting13127702ferreting
recrating121318792recrating
recreating131214582recreating
screwing14288232s_crewing
seceding12288562sec_eding
secerning1246202secerning
secretion11118302secretion
secretions12117852secretions
secretive1446932secretive
serrating10513212serrating
socketing1666382socketing
aerating92821003ae_rating
becarpeting1882793becarpeting
becriming1646363becriming
becrusting1544603becrusting
befretting1644793befretting
berating113220763be_rating
bucketing1835713bucketing
cacheting1737153cacheting
cocreating15310293cocreating
concreting1539873concreting
crating103725203__crating
creating113921953__creating
creping122913653__creping
cresting114017043__cresting
cretin82917913__cretin_
cretins93216423__cretins
crewing133212633__crewing
decanting132510633decanting
decerning1337293decerning
decocting1538123decocting
decorating14312073decorating
decreasing1446523decreasing
decretive1547493decretive
decrying15237413decr_ying
decrypting1943223decrypting
deleting103314423de_leting
depleting1378193depleting
derating103222283de_rating
desecrating1548093desecrating
deserting11713143deserting
docketing1785413docketing
erecting112415063_e_recting
escheating1645883escheating
eschewing1893503eschewing
escorting1237713escorting
escoting1158713esc_oting
escrowing1544813escrowing
estreating11710363estreating
everting122213133_everting
execrating2047883execrating
exerting162211153_exerting
faceting1438783fac_eting
ferreling13136273ferreling
ferretings14133503ferretings
hearting12513123hear_ting
helmeting1545503helmeting
jacketing2345643jacketing
lechering1538443lechering
meeting103314963me__eting
meriting11314693me_riting
necrosing1247703necrosing
obsecrating1644133obsecrating
packeting1836853packeting
pelleting1237953pelleting
picketing1835683picketing
pocketing1875853pocketing
racheting1537793racheting
racketing1647873racketing
recanting122414823recanting
recarpeting1674363recarpeting
recasting122414233recasting
receding122713763rec_eding
rechewing1836493rechewing
reciting113118073rec_iting
recoating121317463recoating
recruiting1347903recruiting
recutting1239483recutting
reerecting1339973reerecting
regrating111316213regrating
regreeting1237343regreeting
regretting1237783regretting
remeeting12311433remeeting
rerenting102617663re_renting
retreating111414773retreating
reverting132315133reverting
rewriting13310413rewriting
rocketing1666973rocketing
sacring103115983sacr__ing
scanting113914763s_canting
scarting113415263s_carting
scatting113311813s_catting
scenting113212813s_centing
scheming1636633s_cheming
scooting113012643s_cooting
scouting112612753s_couting
scraping133310863s_craping
screaking16228243s_creaking
screaming14217833s_creaming
screeding1336323s_creeding
screening1247193s_creening
scribing13238183s_cribing
scrieving1534133s_crieving
scripting1437473s_cripting
scriving14258763s_criving
scrutiny1344773s_crutiny
scrying1338663s_cr_ying
searching1538343searching
searing83330923sear__ing
seating84130683se__ating
secluding1344143secluding
seconding1337613seconding
secrecies1346923secrecies
secret8325063secret___
secretary1444203secretary
secrete9311073secret__e
secreted1138643secret_ed
secreter1038513secret_er
secretes10410473secret_es
secretest1147033secretest
secretly1345183secret_ly
secretor1045683secret_or
secretors1145843secretors
secretory1444603secretory
secrets9311773secret__s
sectoring1239583sectoring
securing11310413sec_uring
sedating103014113se_dating
seeding93719483se__eding
seeing74222143se__e_ing
seeking124016063se__eking
seeling83522003se__eling
seeming103216263se__eming
seeping103817913se__eping
seething1239023se__ething
segmenting1445003segmenting
segregating1445453segregating
segueing1034983segue_ing
selecting12310533selecting
sensating1039253sensating
separating1348643separating
serein63318463se_re_in_
sereins73716123se_re_ins
serging93416673se_r_ging
seriating10916403seriating
sering74731813se_r__ing
serotine8313573se_rotine
serotiny1148573se_rotiny
serrying12167703se_rrying
serving113014983se_r_ving
setting83621393se__tting
severing122013853se_vering
sewering122411093se_wering
sheeting122712833s_heeting
shirting123213613shir_ting
shorting122514803shor_ting
shrewing15228093s_hrewing
sickening1635993sickening
signeting1136223signeting
skirting13289393skir_ting
sleeting93114163s_leeting
smarting113212453smar_ting
snorting92613373snor_ting
sonneting1037003sonneting
sorting83221813s_or_ting
speciating1548123speciating
spectating1546623spectating
spiriting1238413spiriting
spirting112913633spir_ting
sporting112415463spor_ting
spurting113111633spur_ting
starting93116173star_ting
stereoing1037893stereoing
strewing12289853s_trewing
suckering1638103suckering
sweeting123911313s_weeting
telneting1035593telneting
ticketing1635633ticketing
uncrating12813183uncrating
uncreating13310473uncreating
weeting113816053we__eting

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411877.58019609.6
3Display Results1871870.0932010.8
 (SQL Overall)1786911878.09322079.7
 
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.