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

260 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
sensates851113(None) 
senates73322581sen_ates
sensate7311881sensate_
sensated938181sensated
enates64026422_en_ates
penates93321592pen_ates
sedates83418032se_dates
senate63725142sen_ate_
sensately1244282sensately
senses63923942sens__es
seriates82620672seriates
serrates82617012serrates
sesames9310742se_sames
sinuates8310962sinuates
aerates74627493ae_rates
agnates82813193agn_ates
annates72415423_annates
ansate64517863_ansate_
ansated84214003_ansated
arsenates979373arsen_ates
bedmates1349183bedmates
benames112814603ben_ames
benzoates2044093benzoates
berates94126863be_rates
cenotes92814543cen_otes
censes83721803cens__es
censures102211623censures
censuses10187543censuses
centares102913893centares
cerastes101111093cerastes
cerates95428253ce_rates
dealates92716683dealates
debates103718533de_bates
deflates123013943deflates
delates83526283de_lates
denotes83817003den_otes
densities10310793densities
dentate8315153dentate_
dentated10411703dentated
denudates1145583denudates
derates84028893de_rates
deviates12312733deviates
donates83217223don_ates
edentates1046953edentates
elates65032363_e_lates
eluates72014683_eluates
emendates1246073emendates
enate54428143_en_ate_
encages103313783_encages
encases93116053_encases
endites83717063_endites
enfaces122110913_enfaces
engages92912493_engages
enlaces92313393_enlaces
enrages83114853_enrages
ensiles72714833_ensiles
enskies1138573_enskies
enslaves1136393_enslaves
ensnares856893_ensnares
ensues63313813_ens_ues
ensures73315903_ensures
enswathes1543433_enswathes
entases72816273_entases
equates162012323_equates
ergates8314493_ergates
ersatzes1743063_ersatzes
estates74520183_estates
fellates11312753fellates
felsites1138073felsites
ferrates113013413ferrates
gelates83219583ge_lates
gemmates13307673gemmates
generates10312713generates
genettes938303genettes
gentes75324163gen__tes
gestates93213733gestates
gestes75721393ge_s_tes
henbanes1336573henbanes
herniates1247333herniates
hessites1138613hessites
ingates82716913_ingates
inmates92715783_inmates
insensate945383insensate_
instates81615833_instates
kentes105118643ken__tes
legates82917683le_gates
lenites7818443len_ites
lenses64620893lens__es
lysates10317473_lysates
mandates11314093mandates
mediates112814063mediates
menaces112715523men_aces
menages103615393men_ages
mensae84114043mensa_e_
mensas85115853mensa__s
mensches1536293mensches
menses84222453mens__es
menshes12310443mens_hes
messages1138233messages
messmates1346233messmates
metates92720013me_tates
nates55238333__n_ates
negates83215843ne_gates
neonates8310063neonates
pectates122213953pectates
penlites10312273penlites
pennames12287793pennames
pennate93314033pennate_
pennated11299543pennated
pensees9311203pens_ees
penster92811953pens_ter
pensters103012123pens_ters
pentanes10316083pentanes
pesades10310903pe_sades
phenates13611573phen_ates
pulsates1048813pulsates
rebates95123183re_bates
recrates102420363recrates
redates83423873re_dates
reflates113115663reflates
regrates92618393regrates
reinstates1048293reinstates
relates73731433re_lates
remates93827113re_mates
renames92418053ren_ames
rennases848983rennases
renovates1248453renovates
rentes65431193ren__tes
replates102919273replates
resales74724903re_sales
resites74027793re_sites
reslates83619503reslates
restates83423433restates
retastes82212903retastes
sanitates9611733sanitates
sansars73313913sansa_rs
sates54949323___sates
satiates8314633satiates
sausages937003sausages
savates10312953s_avates
seascapes1344813seascapes
seasides938743seasides
seated75131053se__ated
seater64534153se__ater
seaters74028943se__aters
seatmates1157823seatmates
seats54844343se__at_s
seawares1139333seawares
seawater1136603seawater
seawaters1235713seawaters
secretes10410473secretes
sedate73019803se_date_
sedated93714343se_dated
sedater83713623se_dater
sedatest9249393se_datest
seepages1137283seepages
seesawed1243293seesawed
seesaws1034703seesa_ws
seises64026713seis__es
seisures838273seisures
selenates91611353selenates
selvages1236513selvages
senator7313063sen_ator
senators8312953sen_ators
sendals81912263senda_ls
senhores112810993senhores
seniles72618023sen_iles
sennas64214233senna__s
sennets73712583sennet_s
sennits73811283sennit_s
senores73218113sen_ores
sensa54117473sensa___
sensating1039253sensating
sensation9510583sensation
sensations1059853sensations
sense55526823sens__e_
sensed73918163sens__ed
sensei64712593sens__ei
senseis73310643sens_eis
senseless945973senseless
sensibles1145953sensibles
sensitise947293sensitise
sensitises1047643sensitises
sensitives1346133sensitives
sensitizes1946963sensitizes
sensors73514633sens_ors
sensuous845903sensuous
sente56432873sen__te_
sentries81318053sentries
separates11310743separates
sepses84515883seps__es
septages1168263septages
septate9511873septate_
serapes95218103se_rapes
serfages1238233serfages
seriate73722473seriate_
seriated92717023seriated
serrate73017543serrate_
serrated92513433serrated
sesame8311013se_same_
sestet6826203se_s_tet
sestets7911473se_s_tets
sewages1139753se_wages
sienites8311913sien_ites
sinkages1386853sinkages
sinuate7412163sinuate_
sinuated938413sinuated
situates8310373situates
skates104219393s__kates
slates64934063s__lates
snakes103919603s_n_akes
snares65329033s_n_ares
snashes105214753s_nashes
snathes104816493s_n_athes
snaths95112913s_n_aths
solates73523853s_olates
solvates11249673solvates
sonatas7510293son_atas
sonicates11410383sonicates
sorbates10311103sorbates
spates85028173s__pates
speciates13229233speciates
spectates13228813spectates
spenses92913573spens__es
states64337083s__tates
stearates939443stearates
stomates10313343stomates
striates83417083striates
sublates10315003sublates
subsales10310123subsales
subsites10312783subsites
substates111410323substates
sulfates11310793sulfates
summates122610493summates
sunbathes1444113sunbathes
sunbaths1344383sunbaths
sundaes8313093sunda_es
sunsets72911573sunset_s
sunshades1344153sunshades
syenites1138943syen_ites
syngases1245073syngases
syntaxes1843633syntaxes
tannates81911953tannates
tenaces92814513ten_aces
teniases838623teniases
tenses64722553tens__es
tensities9311333tensities
tentages91011043tentages
testates83615453testates
testes65125823te_s_tes
unsated83419933_unsated
unstates81314993_unstates
vendaces1457183vendaces
venenates1247583venenates
venerates12312263venerates
ventages12119773ventages
verstes104014283vers_tes
websites1335183websites
yentes95517603yen__tes
zincates1937743zincates

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 Limit1461622608.92016385.9
3Display Results2602600.1102363.6
 (SQL Overall)1786912609.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.