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

211 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
openest931291(None) 
evenest10312102evenest
keenest11410962keenest
oftenest1148862oftenest
oneness7512142oneness
opencast1244862opencast
opened94311862opene_d
opener83910992opene_r
openers9339492openers
openness1035472openness
opens76118552open_s_
opines84820702opines_
penes75839222_penes_
renest64529712_renest
agenes74720253agenes_
akenes104817343akenes_
anenst63514983anen_st
apexes1539133apexes_
aptest82917513ap_test
aptness9268573aptness
arenes64928393arenes_
behest11314613_behest
benes75536233_benes_
boneyest1347843boneyest
cleanest10310293cleanest
copens106119963copen_s_
deepest10310443deepest
denes65639723_denes_
densest83112473_densest
detest74122843_detest
devest104418703_devest
dienes75719903dienes_
doneness9411513doneness
dopeyness1543473dopeyness
dopiest103315993dop_iest
dopiness11289973dopiness
dueness82310123dueness
dunnest83312263dunnest
earnest7318733earnest
egest65222343__egest
epeeist938863epeeist
epees75219833epe_es_
fainest10417703fainest
fewest12311663_fewest
feyest12311403_feyest
finest94321733_finest
freest95318283fre_est
funest94316863_funest
funnest102912003funnest
geest64829613_ge_est
genes65133093_genes_
genet66038683_gene_t
genets75716663_genets
goldenest1147873goldenest
goneness9310763goneness
greenest9312623greenest
greyest11348343greyest
heppest14228143heppest
honest94822423_honest
hopeless13118303hopeless
hoppiest152610723hoppiest
inanest72115363inanest
leanest7415863leanest
lenes54738523_lenes_
liefest1038443liefest
lievest1048343lievest
loneness8512093loneness
loppiest122410103loppiest
lovefest1444893lovefest
meanest9315703meanest
meekest1336893meekest
merest84725113_merest
modernest1248113modernest
mopiest113014293mop_iest
mopiness12259063mopiness
moreness10911573moreness
nenes55329673_nenes_
nest45548733___nest
newest9314213_newest
oakiest112913923oakiest
obscenest1345823obscenest
obtest81213013o_btest
oddest81710863o_ddest
oddness935313oddness
oftest91212003o_ftest
ogees65119143oge_es_
oiliest72817683oiliest
oldest72114093o_ldest
oldness836403oldness
oleines7313393oleines_
omelet8317073omele_t
omelets938333omelets
omened93711003omene_d
omens75618963omen_s_
onanist7314633onanist
oneriest8313443oneriest
ones46146533o__nes_
onset54730173o__nset
ooziest163411523ooziest
opaquest1943223opaquest
open66427003open___
opening1039923opening
openly1137123open_ly
operant9317223operant
operas8312453operas_
operetta1044303operetta
operose939433operose
opes65942613op__es_
opine77422463opine__
opined95113853opine_d
opponent1246403opponent
oppress1135993oppress
opulent938833opulent
opuses84012243opuses_
orbiest9312413orbiest
orpines94414793orpines_
ovens86217453oven_s_
overeat102620323overeat
overneat112713643overneat
overset102821473overset
ovines94614343ovines_
oxeyes1635893oxeyes_
oyezes1835053oyezes_
ozones1539393ozones_
palest83926223_palest
panes76148693_panes_
pedes85327293_pedes_
peens76428193_peens_
pees65257373_pe_es_
pekes114623563_pekes_
peles75738083_peles_
pendent10314723_pendent
pends85527193_pends_
penis75129323_penis_
pens65649643_pen_s_
pensee8417313_pensee
pent66559073_pen__t
penult8314653_penult
peones83821043_peones_
peres76246643_peres_
pertest9317043_pertest
pest65555293_p__est
pines76048863_pines_
piniest93121133_piniest
pinkest132812623_pinkest
plenist9314333plenist
poetess938933poetess
pokiest133314913pokiest
ponent82821593_ponent
pones74547043_pones_
poorest9312773poorest
popeless1288473popeless
porniest103214313porniest
poshest12312423poshest
poxiest163412253poxiest
prest75736353_p_rest
pretest9517633pretest
priest84125423_priest
propenes122816513propenes_
properest1349663properest
puniest92918093_puniest
punkest132611693_punkest
purest84021933_purest
reest54938093_re_est
renests74014213_renests
retest64028453_retest
revest94623603_revest
ripeness1039363ripeness
ropiest93317773rop_iest
ropiness102311073ropiness
rottenest949603rottenest
sanest64426693_sanest
scenes84520353scenes_
serenest82717623serenest
serest64831613_serest
skenes104616633skenes_
soberest10310353soberest
solemnest1148053solemnest
soleness8814263soleness
soonest7415593soonest
soppiest122511933soppiest
soreness8914793soreness
sparest94616423sparest
spences113413923spences_
spendiest1237523spendiest
spends94714473spends_
spense83912433spen_se
spenses92913573spenses
spent75532833spen__t
sphenes123013163sphenes_
spines85132033spines_
spinet85629753spine_t
spinets94714813spinets
spiniest102813223spiniest
spriest92718643spriest
spryest12247813spryest
sternest8314433sternest
tannest72617853tannest
teeniest82112413teeniest
tenet55542213_tene_t
tenets65518953_tenets
tensest72713313_tensest
topees85519703tope_es_
upends9438763upends_
vainest10315763vainest
waeness102512783waeness
wannest103915003wannest
weeniest112411213weeniest
weest85026773_we_est
woeness1020211543woeness
woodenest1347693woodenest

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.406440125.6
2DLD Change Limit1340272116.06322105.7
3Display Results2112110.0762776.3
 (SQL Overall)1786912116.54527301.9
 
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.