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

196 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
hessites113861(None) 
hessite1038991hessite_
despites11410312despites
felsites1138072felsites
hessians1145052hessians
hessonites1343692hessonites
hissies103915822hissi_es
hussies103213292hussi_es
resites74027792re_sites
respites10513242respites
websites1335182websites
amosites10311233amosites
ascites9312603_ascites
assizes1638453_assizes
beasties102514653beasties
bedsides1246533bedsides
bedsits1037563bedsit_s
besides104814533be_sides
beslimes1246953beslimes
besmiles1237393besmiles
bheesties1443923bheesties
bossies94116833bossi_es
cassines103116613cassines
cassises103811743cassises
cerites94823433ce_rites
cerusites1146523cerusites
cerussites1243183cerussites
cesses84221363cess__es
cessions1039853cessions
cesspits1243663cesspit_s
cheddites1643013cheddites
chedites1438263che_dites
cheshires1744553cheshires
chesses124112633chess__es
cissies94116153cissi_es
coesites101313093coesites
dassies84418663dassi_es
densities10310793densities
depsides1238503depsides
desires81316133de_sires
desisted1039783desisted
desists83611723desist_s
despises1139433despises
despite10410123despite_
despited1248323despited
destines93619663destines
easies64126633_easi_es
elites66027123_e_lites
endites83717063_endites
ensiles72714833_ensiles
eosines73718293_eosines
equites162212493_equites
espies83716803_espi_es
esses56422973_ess__es
essonites945153_essonites
estates74520173_estates
evites94916473_e_vites
excites16310633_excites
felsite1039083felsite_
ferrites112312823ferrites
fesses94820253fess__es
gessoes838293gess_oes
gestates93213723gestates
gestes75721393ge_s_tes
gussies82813303gussi_es
halites103221193h_alites
haplites1339993haplites
hassiums1344273hassiums
hassles103411693hass_les
hastes95727073h_as_tes
hearties11315413hearties
heavies132713873heavi_es
heinies102514543heini_es
heisted113210653heis_ted
heister103613623heis_ter
heisters113413133heis_ters
heists96814633heis_t_s
helices12313723he_lices
helixes1739133he_lixes
hellkites1644633hellkites
hematites141510793hematites
hemlines13310613hemlines
henbits12177003henbit_s
henries102718283henri_es
heresies11312693heresi_es
hermits12312133hermit_s
herniates1247323herniates
heroines112916573heroines
heroizes202610983heroizes
herries104025073herri_es
hesitates1269793hesitates
hessian1035853hessi_an
hessonite1244253hessonite_
hests85829933he_s_t_s
hisses94719353hiss__es
hissier103410503hissi_er
hissiest112911093hissi_est
hissings12556753hissings
homesites1448913homesites
hoplites13310543hoplites
horstes104516113hors_tes
hospices1587633hospices
hostiles11312213hostiles
huskies143212073huski_es
huswifes1742723huswifes
huswives1742933huswives
hyalites14208833hyalites
inosites8312793inosites
jesses135215953jess__es
jesuits1436323jesuit_s
jussives1833843jussives
kernites1269113kernites
lassies74420103lassi_es
lenites7818443le_nites
lessees73510243less_ees
leucites1037333leucites
lewisites1244213lewisites
mesquites20476433mesquites
messages1138233messages
messes84924343mess__es
messiahs1343963messiahs
messier93412923messi_er
messiest103112423messi_est
messiness11248223messiness
messmates1346233messmates
miscites12313783miscites
missies93423983missi_es
missiles103015083missiles
missises103513693missises
missives133212843missives
nesses64718323ness__es
newsies101310383newsi_es
passives13228823passives
pelites93821993pe_lites
penlites10312263penlites
pepsines1239883pepsines
perlites10316353perlites
petites93820203pe_tites
pussies93615693pussi_es
recites93524583re_cites
requites171511763requites
reseizes1759853reseizes
reshines112615443reshines
resides84523283re_sides
resiles74026543re_siles
resisted9312693resisted
resister8311653resister
resisters9310453resisters
resists74414923resist_s
resite64128453re_site_
resited85122423re_sited
resits64725563re_sit_s
resizes164216843re_sizes
reslates83619493reslates
respires10311903respires
respite9513033respite_
respited11410813respited
restates83423413restates
reunites8312473reunites
rewrites11311053rewrites
sassies74719263sassi_es
seasides938743seasides
sensates8511133sensates
sessile739523sessile_
sessions839713sessions
sestines82717243sestines
sissies73716603sissi_es
sites56045433___sites
skites104418033__skites
smites83921923__smites
spites84127333__spites
subsites10312763subsites
suites63727403__suites
tassies74918933tassi_es
tectites1039993tectites
tektites1236613tektites
tensities9311333tensities
teosintes944553teosintes
tergites9310543tergites
termites10313693termites
testates83615443testates
testes65125823te_s_tes
thermites1438043thermites
tussises835433tussises
velites103417303ve_lites
verites103822253ve_rites
versines112213823versines
verstes104014273vers_tes
vestiges1238243vestiges
website1235323website_
wellsites1244673wellsites
weskits1434743weskit_s
wussies103411083wussi_es
yesses93615813yess__es
zeolites1738383zeolites
zoisites1744973zoisites

Search took 9 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.1701051123.5
2DLD Change Limit1461621968.40617387.8
3Display Results1961960.0802450.0
 (SQL Overall)1786911968.65620643.6
 
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.