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

220 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
histones1131280(None) 
histone10312841histone_
distomes11314162distomes
hailstones1344982hailstones
hipbones1546022hipbones
histogen1245562histogen
histogens1344652histogens
histories12412472histories
intones7816542_intones
isotones82210432_isotones
misatones1148932misatones
mistunes10311132mistunes
oilstones946612oilstones
pistoles102514722pistoles
pistons93016372piston_s
stones65130032__stones
tinstones948492tinstones
whinstones1644232whinstones
acetones10310033acetones
astonies8815093_astonies
atones65225773__atones
bhisties1339003bhist_ies
biltongs1133813biltongs
biotopes1246963biotopes
bisons83914373bis_on_s
bistorts10118813bistorts
bistres94017213bist_res
bizones1837823bi_zones
bostons9312903boston_s
brimstones1464383brimstones
buhrstones1592933buhrstones
burstones1187153burstones
capstones1347373capstones
centones10313663centones
cestodes1138203cestodes
chinbones1655033chinbones
chinones13510473chi_nones
chitons122611913chi_ton_s
ciscoes113610733cisco_es
cistrons102710623cistron_s
cistuses1038283cistuses
citoles9312553ci_toles
custodes1136653custodes
cystines1339473cystines
destines93619663destines
diastoles1047493diastoles
dishonest13410773dishonest
disposes11313823disposes
disrobes1139743disrobes
distances12311653distances
distaves12311403distaves
distends10339823distends
distome10313233distome_
distorts91112353distorts
disyokes1656503disyokes
dripstones1343933dripstones
duotones937643duotones
earstones948523earstones
ecotones1039493ecotones
eikones1137853ei_kones
epistomes1346013epistomes
estrones8313323_estrones
eyestones1246323eyestones
felstones1246963felstones
firestones1347113firestones
fishbones1744263fishbones
fistnotes1243783fistnotes
gemstones1245563gemstones
gustoes879873gusto_es
hailstone1244853hailstone_
halftones1545213halftones
hambones1539673hambones
haptenes133810823haptenes
hastened12239103hastened
hastener11259133hastener
hasteners12267813hasteners
hastens106214813hasten_s
hastes95727073hast__es
hastiness122410883hastiness
headstones1465363headstones
heptanes1339003heptanes
heptoses1338373heptoses
hexones17299143h_exones
hiatuses1135773hiatuses
hidroses1237903hidroses
hilloes103815963hillo_es
hipbone1445923hipbone_
hiplines13310593hiplines
hisses94719353his__ses
hissies103915823his_sies
hissings12556753hissings
histamines1575893histamines
histed104420243hist__ed
histidines1444533histidines
histing113720373histin_g
histoid1139823histo_id
histolyses1643393histolyses
historic1388943historic
historied1347773historied
history1339423histo_ry
hists86328373hist___s
hitches153616273hi_tches
hizzoner1942173hizzoner
hizzoners2041633hizzoners
holystones1655243holystones
hones88144493h___ones
hormones13311163hormones
hornstones13106073hornstones
hostages122311693hostages
hostiles11312213hostiles
hustings12378683hustings
hustles103414173hust_les
hysons1237633hys_on_s
icones84616383_i_cones
impones112712253_impones
inkstones1345083inkstones
intines7921113_intines
intone61115433_intone_
intoned8811993_intoned
intoner7811673_intoner
intoners889933_intoners
ionones7313883_ionones
irones64724013_i_rones
isatines8310663_isatines
isogones9217993_isogones
isotone7239983_isotone_
isotopes10228073_isotopes
istles62814983_ist_les
ketones115014503_ketones
keystones1645083keystones
lactones10311233lactones
limestones1245013limestones
listees73416673list_ees
listened9168813listened
listener8158313listener
listeners9147323listeners
listens74014133listen_s
listings93310043listings
litotes7311183li_totes
milestones1246373milestones
millstones1245353millstones
misatone1049763misatone_
misatoned1246693misatoned
miscodes13310423miscodes
misdoes10312493misdo_es
misdone10310863misdone_
mismoves1537293mismoves
mistakes141213413mistakes
mistends11419593mistends
mistimes12612613mistimes
mistiness111911633mistiness
mistune9310653mistune_
mistuned1157723mistuned
mistypes15116713mistypes
misyokes1735513misyokes
mitoses9312183mi_toses
mudstones1245033mudstones
nitons64614903ni_ton_s
oestrones949773oestrones
oilstone847273oilstone_
ostoses71213553_ostoses
oxytones1844053oxytones
peptones12311033peptones
pinbones1238143pinbones
pinones94717073pi_nones
pintoes95117713pinto_es
pipestones1445423pipestones
pishoges1446953pishoges
pistes85325633pist__es
pistole92414313pistole_
pistoled11259593pistoled
pistols93213983pisto_ls
piston83515923piston__
pistous92714383pisto_us
pitons85319043pi_ton_s
postpones1348833postpones
potstones1149213potstones
pristanes11410433pristanes
restokes125213043restokes
restores85222993restores
rhinestones1453343rhinestones
rissoles839113rissoles
scones84521303__scones
sestines82717243sestines
shinbones1454583shinbones
siltstones1043873siltstones
sones55444143__s_ones
stanes64933403__stanes
stokes104821793__stokes
stoles63927673__stoles
stone55431183__stone_
stoned75923143__stoned
stoner65823203__stoner
stoners74817953__stoners
stoney96217353__stoney
stopes84525893__stopes
stores65533663__stores
stoves93818923__stoves
subtones10311383subtones
sunstones947883sunstones
systoles1146483systoles
testons7313563teston_s
thistles1198233thist_les
tinstone848173tinstone_
tiptoes939173tipto_es
tisanes7311853tis_anes
tones56048663___tones
topstones1147013topstones
tritones83413443tritones
unstoned9311043unstoned
veinstones1363733veinstones
viatores11257683viatores
violones1137383violones
viscoses1338343viscoses
visioned1247013visioned
visions10311023vision_s
whetstones1643343whetstones
whinstone1544273whinstone_
whistles14108213whist_les
wishbones1743883wishbones

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622207.29620033.2
3Display Results2202200.0932365.6
 (SQL Overall)1786912207.81222873.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.