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

194 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
hessite103899(None) 
hessites1138611hessites
despite10410122despite
felsite1039082felsite
hessian1035852hessian
hessonite1244252hessonite
resite64128452re_site
respite9513032respite
sessile739522sessile
website1235322website
amosite9313163amosite
assize1538633_assize
beastie92412433beastie
bedside1156843bedside
bedsit9312843bedsit_
bedsits1037563bedsits
beside95114613be_side
beslime1146833beslime
besmile1137463besmile
bheestie1343153bheestie
cassine93817283cassine
cerite84724873ce_rite
cerusite1047763cerusite
cerussite1144013cerussite
cessing103814813cessing
cession939813cession
cesspit1145463cesspit_
cesspits1243663cesspits
cheddite1543953cheddite
chedite1338863che_dite
cheshire1644553cheshire
coesite9713623coesite
dassie74615573dassi_e
density1137583density
depside1138403depside
desire7415303de_sire
desist74818813desist_
desisted1039783desisted
desists83611723desists
despise1038683despise
despited1248323despited
despites11410313despites
destine83719953destine
elite56230183_e_lite
endite73817593_endite
ensile62616473_ensile
eosine64519413_eosine
essonite845733_essonite
estate64719763_estate
evite85317683_e_vite
excite15310883_excite
felsites1138073felsites
ferrite103312753ferrite
fesse86116333fess__e
fessing113812863fessing
fesswise1442353fesswise
festive1339773festive
fissate103010033fissate
fissile10269653fissile
fossate10388603fossate
gestate83614073gestate
geste65920693ge_s_te
gussie72910153gussi_e
halite93624233h_alite
haplite12310703haplite
hassium1236133hassium
hassle93711593hass_le
hastate10313913hastate
haste85927863h_as_te
heinie92512663heini_e
heist87030913heis_t_
heisted113210653heis_ted
heister103613623heis_ter
heists96814633heis_ts
hellkite1544933hellkite
hematite131612153hematite
hemline12311073hemline
hempie132410563hempi_e
henbit111412003henbit_
henbits12177003henbits
henlike1448693henlike
hermit11519443hermit_
hermits12312143hermits
herniae1039043herniae
herniate1148113herniate
heroine103517483heroine
heroize193210963heroize
hesitate1169973hesitate
hessians1145053hessians
hessonites1343693hessonites
hest75950773he_s_t_
hests85829933he_s_ts
hirsute1084523hirsute
hissier103410503hissier
hissies103915823hissies
hissing114213143hissing
homesite1359263homesite
hoplite12311073hoplite
horste94817413hors_te
hospice14117063hospice
hostile10312553hostile
hussies103213293hussies
huswife1642223huswife
hyalite13229473hyalite
inosite7314063inosite
jesse126012833jess__e
jessing153710623jessing
jesuit1339583jesuit_
jesuits1436323jesuits
jussive1734293jussive
kernite1159473kernite
lassie64917743lassi_e
lenite6719983le_nite
lessee64116363less_ee
leucite937753leucite
lewisite1154543lewisite
massive12289773massive
mesquite19537043mesquite
message1037833message
messiah1246793messiah
messier93412923messier
messily12298813messily
messing103916393messing
messmate1246393messmate
miscite11314383miscite
missile92815403missile
missive122413143missive
newsie9138213newsi_e
passive12239593passive
pelite84323003pe_lite
penlite9313243penlite
pensile92713543pensile
pensive122610393pensive
pepsine11310603pepsine
perlite9317313perlite
petite84320653pe_tite
recite83625113re_cite
requite162012483requite
reseize1639553reseize
reshine102816943reshine
reside74224933re_side
resile64627673re_sile
resist64524533resist_
resisted9312693resisted
resister8311653resister
resists74414923resists
resit54241043re_sit_
resited85122423re_sited
resites74027793re_sites
resits64725563re_sits
resize154117723re_size
reslate73520593reslate
respire9411543respire
respited11410813respited
respites10513243respites
restate73824883restate
restive10315933restive
reunite7312713reunite
rewrite10311143rewrite
seaside839693seaside
sensate7311883sensate
session739763session
sestine73017923sestine
site47052413___site
skite95120053__skite
smite75224873__smite
spite75430663__spite
subsite9412873subsite
suite54829563__suite
tassie66017023tassi_e
tectite9310583tectite
tektite1136883tektite
tensile72612733tensile
tensity1039103tensity
tensive10269913tensive
teosinte845543teosinte
tergite8311003tergite
termite9313893termite
tessiture943303tessiture
testate73916233testate
thermite1339033thermite
tussive1035303tussive
verite94323443ve_rite
versine102515173versine
verste94515633vers_te
vespine1237903vespine
vestige1137433vestige
websites1335183websites
wellsite1145133wellsite
weskit1338343weskit_
weskits1434743weskits
yessing113210063yessing
zeolite1638903zeolite
zoisite1635833zoisite

Search took 7 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.1561145455.1
2DLD Change Limit1340271946.73619897.1
3Display Results1941940.0603233.3
 (SQL Overall)1786911946.95225703.5
 
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.