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

207 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
sessile73952(None) 
besmile1137462besmile
ensile62616472_ensile
fissile10269652fissile
hessite1038992hessite
messily12298812messily
missile92815402missile
pensile92713542pensile
resile64627672re_sile
sassily1038722sassily
scissile1044622scissile
seaside839692seaside
sectile9311972sectile
sedile73517232se_dile
senile63420212se_nile
sensible1037852sensible
servile10310642servile
session739762session
sestine73017922sestine
sextile1438572sextile
tensile72612732tensile
aedile73716653ae_dile
assize1538633_assize
bastile9313913bastile
bedside1156843bedside
beguile1056933beguile
beside95114613be_side
beslime1146833beslime
besmiled1335493besmiled
besmiles1237393besmiles
bossily1237563bossily
cassine93817283cassine
centile94217183centile
cessing103814813cessing
cession939813cession
dassie74615573dassi_e
deasil71110983deasil_
decile94619213de_cile
defile105216663de_file
depside1138403depside
desire7415303de_sire
despise1038683despise
despite10410123despite
destine83719953destine
dossil75110903dossil_
dossils8669773dossils
dressily1246443dressily
easily9313023_easily
edile64819493_e_dile
enisle63412093_enisle
ensiled82611433_ensiled
ensiles72714833_ensiles
eosine64519413_eosine
etoile6312263_etoile
exile126117653_e_xile
feasible1376093feasible
febrile1237153febrile
felsite1039083felsite
fertile10311733fertile
fesse86116333fess__e
fessing113812863fessing
fesswise1442353fesswise
festive1339773festive
fossil9379353fossil_
fossils10379013fossils
fusile94313493_fusile
fussily13267603fussily
gassily1137813gassily
gentile83515293gentile
gussie72910153gussi_e
hassle93711593hass_le
hessian1035853hessian
hessites1138613hessites
hostile10312553hostile
jesse126012833jess__e
jessing153710623jessing
jussive1734293jussive
lassie64917743lassi_e
lessee64116363less_ee
massive12289773massive
measle83513223meas_le
message1037833message
messiah1246793messiah
messier93412923messier
messing103916393messing
misfile122611553misfile
missiles103015083missiles
missive122413143missive
mussily12279773mussily
nestle63013953ne_stle
newsie9138213newsi_e
obsessive1443743obsessive
ossicle944483_ossicle
passible1237693passible
passive12239593passive
penile82219603pe_nile
pensil83013333pensil_
pensils92811593pensils
pensive122610393pensive
pepsine11310603pepsine
peskily1635083peskily
pestle83215843pe_stle
possible1245813possible
rassle63813203rass_le
refile95122373re_file
reptile93914083reptile
resail64418733resail_
resailed93613063resailed
resails74616743resails
resale64025543re_sale
rescale93215473rescale
reseize1639553reseize
reshine102816943reshine
reside74224933re_side
resiled84621983re_siled
resiles74026543re_siles
resite64128453re_site
resize154117723re_size
resole64624183re_sole
respire9411543respire
respite9513033respite
restive10315933restive
restyle1038763restyle
retile65929673re_tile
revile94921613re_vile
rissole739783rissole
sassier73413233sassier
sassies74719263sassies
sassing84615553sassing
seasick1346193seasick
seasides938743seasides
seeable91113943seeable
seedily1178583seedily
seine55732873se__ine
seisable10311373seisable
seise54727853se__ise
seisin63715123seisi_n
seising84018863seising
seisins73614393seisins
seisure738193seisure
seize143819503se__ize
selkie102811693selki_e
selle54428313se__lle
semple103212753se_mple
seniles72618023se_niles
sensate7311883sensate
sense55526823sens__e
sensibler1144113sensibler
sensibles1145953sensibles
sensibly1345593sensibly
sensilla845623sensilla
sensillae944113sensillae
sensing84116953sensing
sepsis83011293sepsi_s
septime1138803septime
serail64222673serail_
serails73318363serails
serine65432673se_rine
service1239083service
sesame8311013se_same
sessility1244903sessility
sessions839723sessions
sestina72711973sestina
sestines82717243sestines
setline7313923setline
settle63915663se_ttle
sewable121911173sewable
sexily1638853se_xily
sextiles1537643sextiles
simile83115633s_imile
sissier73711363sissier
sissies73716603sissies
smile74823923__smile
sonsie6614863sonsi_e
spile75230083__spile
stabile9312063stabile
sterile7316603sterile
stile54931573__stile
suasive1037853suasive
subfile122010503subfile
subsale9310543subsale
subside10410453subside
subsite9412873subsite
subtile91912623subtile
suspire937803suspire
sussing84013703sussing
systole1035763systole
tassie66017023tassi_e
tensible1037243tensible
tensive10269913tensive
testicle1037443testicle
testily102910803testily
textile1437223textile
tussive1035303tussive
tussle637143tuss_le
verbile1249863verbile
versicle1366583versicle
versine102515173versine
vesicle12217923vesicle
vespine1237903vespine
vessel937953vessel_
vesseled1243803vesseled
vessels1035933vessels
vestige1137433vestige
website1235323website
yessing113210063yessing
zestily19167563zestily

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.1531167915.0
2DLD Change Limit1340272076.81319672.2
3Display Results2072070.0802587.5
 (SQL Overall)1786912077.04625360.6
 
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.