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

219 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
septages116826(None) 
septage1078401septage_
heptanes1339002heptanes
meltages1148242meltages
metages102714972me_tages
restages92815762restages
scutages1136502scutages
seepages1137282seepages
selvages1236512selvages
septate9511872septate_
septimes1238292septimes
serfages1238232serfages
sewages1139752se_wages
stages75629492s__tages
tentages91011042tentages
ventages12119762ventages
betakes134212523be_takes
cartages11313313cartages
centares102913893centares
cetanes9315133ce_tanes
cottages113310493cottages
cuttages11297223cuttages
deplanes11311203deplanes
depraves1436873depraves
dotages92311793_dotages
ecotages1136973ecotages
ectases92911673_ectases
encages103313783_encages
engages92912493_engages
enrages83114853_enrages
entases72816273_entases
epitases1038933_epitases
escuages1145163escuages
estates74520173_estates
etapes85415293_e_tapes
flotages1237153flotages
footages1239043footages
geotaxes1644743geotaxes
gestates93213723gestates
hectares1338853hectares
hektares1535813hektares
helotages1346123helotages
heptads1335873hepta_ds
heptagon1443573heptagon
heptagons1543453heptagons
heptane1238363heptane_
heptoses1338373heptoses
herbages1437083herbages
heritages1346713heritages
hostages122311693hostages
keelages1335743keelages
leafages1244623leafages
leakages1334933leakages
meltage1037953meltage_
menages103615393me_nages
messages1138233messages
metage93114453me_tage_
metates92720003me_tates
mintages111110513mintages
montages111412183montages
outages82317323_outages
pages85235073__p_ages
peages94321843__peages
pectases122411183pectases
pectates122213933pectates
peerages1189883peerages
pelages10714613pe_lages
pentanes10316073pentanes
peonages1138473peonages
peptalks1653843peptalks
peptides132610253peptides
peptizes21269853peptizes
peptones12311033peptones
phages125213513__phages
pipages1289423pip_ages
pipeages1336423pipeages
plages94520153__plages
portages112613223portages
postages112815323postages
potages102416423_potages
pottages112910453pottages
reimages1138373reimages
repaves123513653rep_aves
replaces123114123replaces
replates102919263replates
reportages1344383reportages
reptiles103913063reptiles
restage83316183restage_
restaged103011853restaged
restates83423413restates
retags73414303re_tag_s
retakes113718863re_takes
retapes93917423re_tapes
retaxes143615093re_taxes
reuptakes1543213reuptakes
rootages939093rootages
sabotages1244433sabotages
sages65339063s___ages
salvages1238123salvages
sapsagos1143773sapsagos
sausages937003sausages
savages1139973s_avages
scalages113010253scalages
sceptres1244993scept_res
scutage1036333scutage_
seabags1037483seabag_s
seaplanes1148713seaplanes
seatmates1157813seatmates
seawares1139333seawares
sectaries11312233sectaries
sedates83418033se_dates
sedges83817793se__dges
seepage1037543seepage_
seethes103613743seet_hes
seitans73312303seita_ns
selvage1136553selvage_
selvaged1334343selvaged
senates73322583se_nates
sensates8511133sensates
sentries81318053sentries
sepaled10510593sep_aled
sepals85217373sep_a_ls
separates11310733separates
sepias83616103sepia__s
sepses84515883sep__ses
septa75518083septa___
septal84513383septa__l
septaria1047413septaria
septet8921133sept__et
septets998953sept_ets
septettes1144913septettes
septics112810433sept_ics
septime1138783septime_
septs75420603sept___s
septums1135743sept_ums
septuples1342903septuples
serapes95218103se_rapes
serfage1138403serfage_
serges74225963se__rges
seriates82620663seriates
serrates82617003serrates
sesames9310743se_sames
sestines82717243sestines
setae56026223se_ta_e_
settees73513633se_ttees
settles73916003se_ttles
sewage10310733se_wage_
sewerages1345353sewerages
sextains15246813sextains
sextans14349263sexta_ns
sextants15287383sextants
sextiles1537643sextiles
shitakes1546113shitakes
shortages1336513shortages
signages1037473signages
silages82514443s_ilages
sinkages1386853sinkages
slippages1483983slippages
soakages1336143soakages
socages101012053s_ocages
soccages1336383soccages
soilages9189673soilages
soutanes8312933soutanes
spaces104722633s_p_aces
spades94222583s_p_ades
spaes76029973s_p_a_es
spales84728103s_p_ales
spares84834553s_p_ares
sparges104016333s_parges
spates85028173s_p_ates
spathes125116533s_pathes
spectates13228813spectates
spinages11289293spinages
splakes1349673s_plakes
sponges10311043s_ponges
sprags95715823s_prag_s
spurges104111653s_purges
stades74626243s__tades
stage65330193s__tage_
staged84521563s__taged
stager74821343s__tager
stagers84116673s__tagers
stagey105915583s__tagey
stags66226743s__tag_s
stakes103927293s__takes
stales65538293s__tales
stanes64933403s__tanes
stapes85028733s__tapes
stares66038753s__tares
stases64225563s__tases
states64337083s__tates
staves94525193s__taves
stealages1046043stealages
steerages1046483steerages
stepdames1443333stepdames
stoppages1444693stoppages
storages9311103storages
stowages1236473stowages
substages12127353substages
sullages939973sullages
surtaxes1536513surtaxes
swages104417073s__wages
syntagms1442723syntagms
syntaxes1843633syntaxes
tentage81010643tentage_
testates83615443testates
unitages938273unitages
upstages11147373upstages
uptakes1336593_uptakes
vantages12119023vantages
ventage11109623ventage_
vestiges1238243vestiges
vintages12118273vintages
voltages1237253voltages
waftages15105393waftages
wantages12109023wantages
wastages12109753wastages
wattages12106783wattages
webpages1643053webpages

Search took 10 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.310576422.6
2DLD Change Limit1461622199.19015904.5
3Display Results2192190.0762881.6
 (SQL Overall)1786912199.57618660.3
 
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.