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

232 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
histone1031284(None) 
histones11312801histones
distome10313232distome
hailstone1244852hailstone
hipbone1445922hipbone
histing113720372histing
histogen1245562histogen
histoid1139822histoid
history1339422history
intone61115432_intone
isotone7239982_isotone
misatone1049762misatone
misdone10310862misdone
mistune9310652mistune
oilstone847272oilstone
pistole92414312pistole
piston83515922piston_
pistons93016372pistons
stone55431182__stone
tinstone848172tinstone
whinstone1544272whinstone
acetone9310793acetone
astony9510523_astony
atone56527983__atone
bhistie1236773bhist_ie
biltong1034683biltong
biotope1146623biotope
bison75716983bis_on_
bisons83914373bis_ons
bistate9313823bistate
bistort91216523bistort
bistre83815023bist_re
bizone1738603bi_zone
boston8513043boston_
bostons9312903bostons
brimstone1354623brimstone
buhrstone14103153buhrstone
burstone1057133burstone
capstone1237653capstone
cestode1037963cestode
chinbone1555163chinbone
chinone12510153chi_none
chiton112612393chi_ton_
chitons122611913chi_tons
cistron9299883cistron_
cistrons102710623cistrons
citole8311503ci_tole
cystine1239333cystine
destine83719953destine
diastole947563diastole
dispose10312763dispose
disrobe1038993disrobe
distance11311853distance
distant83519953distant
distend93312073distend
distent84120853distent
distomes11314163distomes
distort81120333distort
disyoke1546233disyoke
dripstone1244153dripstone
drystone1245123drystone
duotone836893duotone
earstone848603earstone
ecotone938583ecotone
epistome1246263epistome
estrone7413953_estrone
eyestone1146533eyestone
felstone1146863felstone
firestone1247423firestone
fishbone1644663fishbone
fisting113818123fisting
fistnote1144323fistnote
gemstone1145843gemstone
hailstones1344983hailstones
halftone1445163halftone
hambone1439313hambone
haptene123810933haptene
hastate10313913hastate
haste85927863hast__e
hasten95718563hasten_
hastened12239103hastened
hastener11259133hastener
hastens106214813hastens
hasting114725193hasting
headstone1365473headstone
heisting123411043heisting
heptane1238363heptane
heptose1237493heptose
hexone16289233h_exone
hilting113316893hilting
hinting113919223hinting
hipbones1546023hipbones
hipline12311423hipline
hircine1239143hircine
hisn79620933his__n_
hissing114213143hissing
hist76551543hist___
histamine1476903histamine
histed104420243hist_ed
histidine1345063histidine
histogens1344653histogens
historic1388943historic
historied1347773historied
histories12412473histories
hists86328373hist__s
hitmen11239193hi_tmen
hitting113017273hitting
hizzoner1942173hizzoner
hoisting123610903hoisting
holystone1555473holystone
hone77549323h___one
hormone12410503hormone
hornstone1266073hornstone
hostage113111233hostage
hostile10312553hostile
hosting114318383hosting
hustle93113993hust_le
hyson1138693hys_on_
hysons1237633hys_ons
impone103011863_impone
inkstone1245413inkstone
intine61021983_intine
intoned8811993_intoned
intoner7811673_intoner
intones7816543_intones
ionone6313443_ionone
irone55126363_i_rone
isatine7311763_isatine
isogone8237913_isogone
isotones82210433_isotones
isotope9227783_isotope
istle52214713_ist_le
ketone105014533_ketone
keystone1545333keystone
lactone9311413lactone
limestone1144813limestone
lissome937583lissome
listee64223063list_ee
listen64816813listen_
listened9168813listened
listener8158313listener
listens74014133listens
listing84020593listing
milestone1146433milestone
millstone1145423millstone
misatoned1246693misatoned
misatones1148933misatones
miscode12310413miscode
mismove1437083mismove
mistake131312623mistake
mistend103812523mistend
mistime11312613mistime
misting103623383misting
mistook1337153mistook
mistuned1157723mistuned
mistunes10311133mistunes
mistype14126523mistype
misyoke1635823misyoke
mudstone1145553mudstone
niton55418283ni_ton_
nitons64614903ni_tons
nonhistone1354233nonhistone
oestrone849973oestrone
oilstones946613oilstones
oxytone1744203oxytone
peptone11310763peptone
pinbone1138183pinbone
pipestone1345503pipestone
piscine11610973piscine
pishoge1336693pishoge
piste75824603pist__e
pistol83313333pisto_l
pistoled11259593pistoled
pistoles102514723pistoles
pistols93213983pistols
pistou83211843pisto_u
pistous92714383pistous
piton76121583pi_ton_
pitons85319043pi_tons
postpone1248693postpone
potstone1039423potstone
pristane10310343pristane
pristine10313503pristine
reshone102414163reshone
restoke116113903restoke
restore75822983restore
rhinestone1353213rhinestone
rissole739783rissole
schistose1443503schistose
scone74621833__scone
sestine73017923sestine
shinbone1354473shinbone
shone83725983__shone
siltstone943913siltstone
sone46649983__s_one
stane55933003__stane
stoae55024263__stoae
stoke94922513__stoke
stole54928813__stole
stoned75923143__stoned
stoner65823203__stoner
stones65130033__stones
stoney96217353__stoney
stony85818643__stony
stope74727243__stope
store56333813__store
stove85220253__stove
subtone9310343subtone
sunstone847793sunstone
systole1035763systole
teston6313303teston_
testons7313563testons
thistle10107803thist_le
tinstones948493tinstones
tiptoe838283tipto_e
tisane6311573tis_ane
tone46953743___tone
topstone1046883topstone
tritone73613883tritone
unstoned9311043unstoned
veinstone1253853veinstone
violone1037153violone
viscose1237863viscose
vision9311313vision_
visioned1247013visioned
visions10311023visions
whetstone1543243whetstone
whinstones1644233whinstones
whisting15329543whisting
whistle13107533whist_le
wishbone1644293wishbone
wisting113519743wisting

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 Filter1786911340270.436409841.7
2DLD Change Limit1340272326.70319995.1
3Display Results2322320.0932494.6
 (SQL Overall)1786912327.23224708.4
 
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.