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

182 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
sealants8261074(None) 
sealant73118301sealant_
seawants11337971seawants
alants67722022__alants
gelants82611442ge_lants
gellants9308282gellants
peasants1038262peasants
replants102811242replants
savants1038652s_avants
sealifts1135472sealifts
seaplanes1148712seaplanes
seawans10379942seawan_s
seawant103613412seawant_
secants93413892se_cants
servants1137992servants
sextants15287382sextants
slants64819082s__lants
adamants1186343adamants
alands75418373__alands
alans55636173__alan_s
alant55742293__alant_
ashplants1443533ashplants
assailants1052863assailants
bezants1877343be_zants
bezzants1843643bezzants
callants104112143callants
coolants1039943coolants
dealate83617843deala_te
dealates92716683dealates
dealings103510703dealings
decants103514443de_cants
deplanes11311213deplanes
descants112910143descants
deviants1236733deviants
eclats8313033_ecla_ts
elands74914773_e_lands
elans55527753_e_lan_s
elints65816423_e_lints
eluants737583_eluants
errants7410633_errants
exhalants1963263exhalants
explants1737023explants
fenlands1245183fenlands
gallants93310373gallants
gelant72821673ge_lant_
gellant83214053gellant_
headlands1444903headlands
implants1237883implants
inhalants1244473inhalants
leadplants1352593leadplants
levants1037723le_vants
mediants11299493mediants
peasant9314923peasant_
pedants10310113pe_dants
pendants1139093pendants
pennants1037063pennants
pheasants1443723pheasants
pieplants1355433pieplants
plants84921803__plants
reactants1146623reactants
readapts1145583readapts
reagents959623reagents
realists83014843realists
reallots837993reallots
recants93217093re_cants
regrants9310013regrants
relands85214883re_lands
relaxants1643243relaxants
relents74018503re_lents
remnants1036843remnants
replans92814943replan_s
replant93318533replant_
saints65122423s_a_ints
salaams997703s_alaams
salads75316963s_ala_ds
salals65120083s_ala_ls
salamis9313513s_alamis
salients839563s_alients
salinas73116093s_alinas
salines74029413s_alines
sallets73719653s_allets
salons63823693s_alon_s
saltant7316773s_altant_
salts55431883s_al__ts
sarans64224433s_aran_s
satangs8479713s_atangs
savant9416043s_avant_
scablands1443783scablands
scalades11258803scalades
scalados11276083scalados
scalages113010253scalages
scalares103210983scalares
scalars93711903scala_rs
scalenus1045543scalenus
scants85219723s__cants
seabags1037483seaba_gs
seaboots1047093seaboots
seacoasts1144193seacoasts
seacrafts1443703seacrafts
seafronts1244383seafronts
sealable101512693sealable
sealers74323553seal_ers
sealift10312793sealift_
sealing83528563sealin_g
seals54839693seal___s
seaman84015903seaman__
seamanly1345403seamanly
seamarks1445303seamarks
seamounts1143683seamounts
seaplane1049163seaplan_e
seaports1038463seaports
seasons72614233season_s
seatings93614303seatings
seats54844343se__a_ts
seawalls1145233seawalls
seawan94111223seawan__
seawards1237203seawards
seawares1139333seawares
seaways13307513seawa_ys
secant84023293se_cant_
sedans74816093se_dan_s
segments1138903segments
seitans73312303seitan_s
sejant133114483se_jant_
sejeant1489723sejeant_
seladangs1142383seladangs
selahs9313213se_la_hs
selects91912143se_lects
sellouts837493sellouts
sequents1756993sequents
sergeants10115593sergeants
serjeants1673963serjeants
serpents102410373serpents
serranos857863serranos
servant10313623servant_
setenants945973setenants
setlines8312743setlines
sewans95215903se_wan_s
sextans14349263sextan_s
sextant142911963sextant_
shallots11319503shallots
shamans123610903shaman_s
shealings13317563shealings
shetlands1343743shetlands
siamangs1144063siamangs
sibilants11134803sibilants
silanes72517163s_ilanes
silents73514493s_ilents
simulants1144993simulants
sklents11348163s_klents
slangs75615343s__langs
slant55238703s__lant_
slanty95114843s__lanty
slats55436903s__la_ts
smalts85214893smal__ts
solands84412343s_olands
solanos74412853s_olanos
solans64122493s_olan_s
sonants7511233s_onants
spirants1088283spirants
splats84817303s_pla_ts
splents93912133s_plents
splints94511743s_plints
stalags838643stala_gs
stalwarts1243813stalwarts
statant7313123statant_
stealages1046043stealages
stealings10318853stealings
sterilants1044073sterilants
sunlands936383sunlands
supplants1344873supplants
sweatpants1551763sweatpants
talents7312013_talents
teacarts10116073teacarts
tenants7311013te_nants
valiants1137793_valiants
versants1137783versants
weasands1244563weasands
weazands2143333weazands
wetlands1244763wetlands
yealings12257703yealings
zealots1636763zeal_ots

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.1561145455.1
2DLD Change Limit1461621828.89016441.2
3Display Results1821820.1401300.0
 (SQL Overall)1786911829.18619452.5
 
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.