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

122 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
benzole183713(None) 
benzol1756991benzol_
benzoles1936991benzoles
benzols1836671benzols
beanpole1244332beanpole
benzal1739642benzal_
benzene1836342benzene
benzine1839342benzine
benzoate1944882benzoate
benzoic2045032benzoic
benzoin1846262benzoin
benzoyl2143362benzoyl
benzoyls2242442benzoyls
benzyl2034162benzyl_
benzyls2133672benzyls
anole55330373_an_ole
azole145118033__azole
bandore10611633bandore
bangle94018953ban_gle
beadle93314683be_adle
beagle93612593be_agle
beanpoles1344313beanpoles
become123312593be_come
bedazzle1942143bedazzle
bedroll1055553bedroll
bedsore1057803bedsore
beetle8311673be_etle
befool1137713befool_
befooled1434803befooled
befools1236433befools
before11410153be_fore
begone9512133be_gone
beguile1056933beguile
behold1247343be_hold
behoove1553773behoove
behove14207203be_hove
belle75827833be__lle
bemuzzle2072533bemuzzle
bename103316073ben_ame
bendable131510853bendable
bendee94121023ben_dee
bene66439493ben___e
benne76521123ben__ne
bento75922953bento__
bentos86218303bento_s
benzenes1946853benzenes
benzin1738933benz_in
benzines1938213benzines
benzins1838693benzins
benzoates2044093benzoates
benzoins1945573benzoins
benzylic2442283benzylic
bernicle1245443bernicle
besmile1137463besmile
besmoke15416623besmoke
bespoke15468113bespoke
bezel165215173be_zel_
bezels173712283be_zels
bezil163812883be_zil_
bezils1711310603be_zils
bezoar1736913be_zoar
biennale1044093biennale
bindle94516263bin_dle
binocle1136493binocle
bizone1738603b_izone
bole66448693b___ole
bonze165119353bonz__e
bricole112810493bricole
bundle94315573bun_dle
bunghole1444183bunghole
bungle97116113bun_gle
canzone1858813canzone
cenacle1139123cenacle
cenote83715843cen_ote
centile94217183centile
cineole91010003cineole
condole102914953condole
console92715983console
denote74118043den_ote
diazole1736793diazole
enable83318483_enable
encode9310443_encode
encore8314773_encore
enfold10137613_enfold
enisle63412093_enisle
ennoble935633_ennoble
enol45823823_en_ol_
enols54718403_en_ols
enrobe86610793_enrobe
enrol51014283_enrol_
enroll61110073_enroll
enrols61213383_enrols
ensile62616473_ensile
enzyme2054343_enzyme
evzone1894683_evzone
fenagle11197153fenagle
genome94312193gen_ome
gentile83515293gentile
gentle74014513gen_tle
indole74516053_indole
insole63515863_insole
keyhole1764433keyhole
manhole12311343manhole
menfolk1643883menfolk
penile82219603pen_ile
pensile92713543pensile
pentode1039893pentode
pentose9311593pentose
petiole9311303petiole
pinhole122010433pinhole
pinole83218783pin_ole
pozole1758913_pozole
resole64624183re_sole
rezone153814783re_zone
senile63420213sen_ile
teazle15329553teaz_le
tenable93214493tenable
tenfold1145713tenfold
tensile72612733tensile
venose9310843ven_ose
venule94411763ven_ule
zeppole2043493zeppole

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271228.42315912.0
3Display Results1221220.0333697.0
 (SQL Overall)1786911228.60920756.3
 
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.