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

236 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
extents14261017(None) 
extends15227111extends
extent132714911extent_
detents83615152detents
eluents738702eluents
entente7412952entente
ententes8312772ententes
events94814072e_vents
excepts1885202excepts
exerts133712292ex_erts
existents1644982existents
expects1866882expects
expends17217082expends
experts1659062experts
exsects1655572exsects
exserts1467012exserts
extant132714752extant_
extend14267522exten_d
externes1539832externes
externs1438232externs
extincts1743472extincts
extorts1447752extorts
intents72115702intents
latents75214312latents
patents94815202patents
sextants15287382sextants
sextets1497142sexte_ts
stents65019452_stents
tents56434212__tents
absents93510723absents
accents113511233accents
advents11309473advents
agents74816293_agents
aments85219803_aments
argents84014853argents
arpents93613083arpents
ascents93812553ascents
assents74512223assents
attends8257593attends
attent62818323attent_
attests7278813attests
bents76033693__bents
brents84717273_brents
butenes9313033butenes
catenas9313113catenas
cements112714223cements
cents74730333__cents
clients938093clients
coextends1942323coextends
contents104018213contents
dements103016623dements
dents65031803__dents
descents112511203descents
detects104011093detects
detent73624483detent_
detente83313603detente
detentes92712873detentes
detests83711743detests
docents102810803docents
eaten55323053eaten__
eaters65535953eate_rs
eatings84616443eatings
ebbets10376833ebbe_ts
effects1535283effects
egests74411253e_gests
egrets72712243egre_ts
ejects15409953e_jects
elects83315003e_lects
elements10312173elements
elints65816423e_lints
eluants737583eluants
eluent6315483eluent_
emends95711433e_mends
emmets10349153emme_ts
enters64425643ente_rs
entrants8311753entrants
entreats839773entreats
erects84116183e_rects
errants7410643errants
esteems935243esteems
esters64627733este_rs
estreats839423estreats
ethenes103313873ethenes
ethnos947053e_thnos
etnas54713933e_t_nas
evens84817103e_ven_s
event85924443e_vent_
everts94514893e_verts
exacts15359613ex_acts
exalts13328313ex_alts
examens1637193examen_s
exceeds1733843exceeds
excels1536663exce_ls
except1797653except_
excerpts1943743excerpts
excess1546053exce_ss
excitants1864393excitants
execs14539723ex_e_cs
exempts1844023exempts
exert124624143ex_ert_
exes116530813ex_e__s
exeunt1338703exeunt_
exhalents1983513exhalents
exhorts1746313exhorts
exigent1539513exigent_
exines135715803ex_ines
existent1548263existent_
exists134710913ex_ists
exits125515913ex__its
exogens1536883exogen_s
exons125813343ex_on_s
expands17195733expands
expats1537683ex_pats
expect1758903expect_
expels1547173expe_ls
expend16247503expen_d
expense16127873expense
expenses17138373expenses
expert15515353expert_
explants1737023explants
exponents1844333exponents
exports1647983exports
exsecants1893403exsecants
exsect1558503exsect_
exsert13414363exsert_
extended17135833extended
extender16146333extender
extenders17125673extenders
extensity1944723extensity
extensor1543913extensor
extensors1644083extensors
extenuate1645003extenuate
extenuates1744473extenuates
extern1348473exte_rn
external1577223external
externals1666623externals
externe1438573externe
extinct1646903extinct
extolls1444603extolls
extolments1944403extolments
extols1337683ext_ols
extort13513973extort_
extracts1747623extracts
extranets1646363extranets
extras13310223ext_ras
extremes1756053extremes
exults13257633ex_ults
ferments13311473ferments
fitments1376793fitments
foments122912053foments
gents65729613__gents
gerents82612923gerents
hents87330743__hents
hutments1345603hutments
incents92414533incents
indents83114663indents
intends8239963intends
intent63122773intent_
invents102812053invents
ketenes114813503ketenes
laments94314853laments
latens64620213laten_s
latent64124303latent_
latests73910313latests
loments93413473loments
moments113113123moments
motets84216193mote_ts
mutants938583mutants
neatens73310403neaten_s
obtests9136233obtests
octants9128733octants
octets839403octe_ts
orients7311583orients
outeats72215703outeats
oxters134813273oxte_rs
parents93418123parents
patens84820863paten_s
patent84524923patent_
patients1088763patients
pectens11189203pecten_s
pendents1139413pendents
penitents1147703penitents
pentenes10315633pentenes
percents122713373percents
perpents122312043perpents
portents103512823portents
potent84223353potent_
reagents959623reagents
regents83416543regents
relents74018503relents
rents55935183__rents
repents93717623repents
rerents73319423rerents
resents74221223resents
retenes76324623retenes
retests73813853retests
retints74717013retints
rodents8611543rodents
scents85317023_scents
segments1138903segments
sentients948463sentients
septets998953septe_ts
sequents1756993sequents
serpents102410373serpents
sestets7911473seste_ts
sextans14349263sextan_s
sextant142911963sextant_
sextet13916873sexte_t_
sextette1544073sextette
sextettes1643923sextettes
sextons143710413sexton_s
silents73514493silents
sklents11348163sklents
splents93912133splents
stenos63915773_stenos
stent55634513_stent_
stets55423913_ste_ts
stints65119763_stints
stunts65615253_stunts
talents7312013talents
teats55636813__teats
tends65425583__tends
tenets65518953__tenets
tens45647413__ten_s
tent46159863__tent_
tenth85421833__tenth
tenths94412663__tenths
tenty86121603__tenty
tests56530193__tests
tets45847463__te_ts
texts125515043__texts
tints56030923__tints
urtexts1433143urtexts
vents86125933__vents
vestments1486813vestments
wisents10249063wisents

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.406440125.6
2DLD Change Limit1340272366.62320236.6
3Display Results2362360.0802950.0
 (SQL Overall)1786912367.10925135.9
 
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.