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

147 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
isotone723998(None) 
isogone8237911isogone
isotones82210431isotones
isotope9227781isotope
duotone836892duotone
ecotone938582ecotone
histone10312842his_tone
intone61115432i_ntone
ionone6313442i_onone
isatine7311762isatine
isodose845372isodose
isogon7227542isogon_
isogones9217992isogones
isogons8217612isogons
isogony11215452isogony
isoline7314012isoline
isotonic10158322isotonic
isotopes10228072isotopes
isotopy12215122isotopy
isotype12224952isotype
misatone1049762misatone
stone55431182_s_tone
acetone9310793acetone
astony9510523as_tony
atone56527983__atone
biotope1146623biotope
bisontine1145673bisontine
boston8513043boston_
bostons9312903bostons
botonee9311833_botonee
colone85425003_colone
croton84415453croton_
crotons93714373crotons
distome10313233dis_tome
duotones937643duotones
ecotones1039493ecotones
estrone7413953estrone
fishbone1644663fishbone
histones11312803his_tones
impone103011863i_mpone
inkstone1245413inkstone
inosine7314283inosine
intine61021983i_ntine
intoned8811993i_ntoned
intoner7811673i_ntoner
intones7816543i_ntones
iodine74618653i_odine
ionones7313883i_onones
irone55126363i__rone
ironstone945753ironstone
isagoge943933isagoge
isatin6412213isatin_
isatines8310663isatines
isatins7310773isatins
isobare946343isobare
isobutane1152723isobutane
isobutene1152363isobutene
isochore1355863isochore
isochrone1444313isochrone
isocline1047293isocline
isoform1244963isoform
isogeny11196363isogeny
isogonal944673isogonal
isogonic11187253isogonic
isogonies10207263isogonies
isolate7313923isolate
isolines8312303isolines
isolog737403isolo_g
isologs837433isologs
isologue944613isologue
isonomy1245263isonomy
isooctane1152783isooctane
isophote1376573isophote
isopod935913isopo_d
isopods1045573isopods
isoprene1045613isoprene
isotach1244953isotach
isothere1145793isothere
isotopic12187293isotopic
isotopies11207353isotopies
isotropy1344233isotropy
isotypes13234853isotypes
isozyme21103293isozyme
istle52214713is_t_le
ketone105014533_ketone
kiloton1196313kiloton_
kilotons1286313kilotons
lactone9311413lactone
microtone1349673microtone
misatoned1246693misatoned
misatones1148933misatones
misdone10310863mis_done
mistune9310653mis_tune
monotone10310153monotone
myotome1445483myotome
nicotine1058473nicotine
oilstone847273oilstone
oxytone1744203oxytone
ozone14310613__ozone
peptone11310763peptone
photon1111514833photon_
photons123814433photons
pistole92414313pis_tole
piston83515923pis_ton_
pistons93016373pis_tons
postpone1248693postpone
propone112716303propone
proton84318893proton_
protons93118003protons
scone74621833_s_cone
seton55223543_seton_
setons64620173_setons
setose65114773_setose
shone83725983_s_hone
soigne74310033_soigne
solon55026133_solon_
solons65120023_solons
someone938813_someone
somoni8310743_somoni
sone46649983_s__one
soon46240503_so_on_
sooner64220463_so_oner
soothe94214853_soothe
sotol54917653_soto_l
sotols63714473_sotols
soutane7312063_soutane
sozine15712353_sozine
stane55933003_s_tane
stoae55024263_s_toae
stoke94922513_s_toke
stole54928813_s_tole
stoned75923143_s_toned
stoner65823203_s_toner
stones65130033_s_tones
stoney96217353_s_toney
stony85818643_s_tony
stooge73811663_stooge
stope74727243_s_tope
store56333813_s_tore
stove85220253_s_tove
subtone9310343subtone
tinstone848173tinstone
tone46953743___tone
tritone73613883tritone
violone1037153violone
wishbone1644293wishbone
woodtone1245153woodtone

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.406440125.6
2DLD Change Limit1340271477.23618522.2
3Display Results1471470.0602450.0
 (SQL Overall)1786911477.70223200.6
 
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.