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

198 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
benzols183667(None) 
benzol1756991benzol_
benzole1837131benzole
benzoles1936991benzoles
benzoyls2242441benzoyls
benzyls2133671benzyls
befools1236432befools
bentos86218302bento_s
benzal1739642benzal_
benzins1838692benzins
benzoic2045032benzoic
benzoin1846262benzoin
benzoins1945572benzoins
benzoyl2143362benzoyl
benzyl2034162benzyl_
bezels173712282be_zels
bezils1711310602be_zils
enols54718402_en_ols
enrols61213382_enrols
aeneous739893aeneous
babools11319453babools
bancos104713893banco_s
bandogs1138363bandogs
banjoes16317313banjoes
banjos15378893banjo_s
banzais1837163banzais
bazoos173212623b_azoos
beacons11410733beacons
beanos85516513beano_s
beanpole1244333beanpole
beanpoles1344313beanpoles
bebops1237623be_bops
beckons15279143beckons
beclogs1237073beclogs
bedells10379363bedells
bedels94015273be_dels
bedroll1055553bedroll
bedrolls1144673bedrolls
beezers18349243beezers
befalls12349123befalls
befogs1246453be_fogs
befool1137713befool_
befouls1236053befouls
begalls10319163begalls
behold1247343be_hold
beholds1336423be_holds
behowls1534443behowls
beknots1335083beknots
bellows124313303bellows
bells76432163be__lls
belons84119413be_lons
belows114614183be_lows
bels66142493be___ls
benames112814603benames
benches143918603benches
bendays13327513bendays
bendees103913863bendees
benders104021063benders
bends85628973ben__ds
bendys12518383ben_dys
benes75536233ben__es
benisons1037043benisons
bennes86019013ben_nes
bennets94712163bennets
bennies93917313bennies
bennis84314803ben_nis
benomyls1542983benomyls
bens65945703ben___s
benthons1337973benthons
benthos1238373benthos
bento75922953bento__
bents76033693ben__ts
benumbs1333543benumbs
benzene1836343benzene
benzenes1946853benzenes
benzin1738933benz_in
benzine1839343benzine
benzines1938213benzines
benzoate1944883benzoate
benzoates2044093benzoates
benzylic2442283benzylic
beryls11107883be_ryls
besnows1245153besnows
besoms105712733be_soms
besots86415453be_sots
bestows1248863bestows
betels84515063be_tels
bethels1238533bethels
betons84919553be_tons
bettors93312473bettors
bevels113913983be_vels
bevors111610343be_vors
bewails1277553bewails
bezel165215173be_zel_
bezil163812883be_zil_
bezoar1736913be_zoar
bezoars1836793be_zoars
bingoes104013983bingoes
bingos95514793bingo_s
binocs1039923bin_ocs
blazons1836163blazons
bonbons1139333bonbons
bongoes104314113bongoes
bongos95316653bongo_s
bonzes175116103bonz_es
borneols1046343borneols
borzois1835833borzois
bozos165216863b_ozo_s
brazils1867753brazils
buncos104011593bunco_s
bunions92210473bunions
bunkos124210323bunko_s
censors93611843censors
centals94317053centals
centos85920463cento_s
cineols9128853cineols
consols92914073consols
danazols1843083danazols
denials84114133denials
dentals83915393dentals
dentils84115583dentils
dewools1145593dewools
donzels1735393donzels
endows104610423_endows
enfold10137613_enfold
enfolds11136253_enfolds
enjoys1644603_enjoys
enol45823823_en_ol_
enows85115493_en_ows
enrol51014283_enrol_
enroll61110073_enroll
enrolls7108093_enrolls
ensouls736033_ensouls
entoils7810733_entoils
envois988703_envois
envoys1255143_envoys
enzyms2063433_enzyms
extols1337683_extols
fennels10387903fennels
genoas74013623gen_oas
genoms94412483gen_oms
genros74211333genro_s
gentoos838633gentoos
ginzoes1735433ginzoes
indols74714203_indols
kendos114510663kendo_s
kennels11387193kennels
kenos95220623ken_o_s
ketols104210763ke_tols
lenos56024863len_o_s
lentils73912973lentils
lentos65317403lento_s
lintols7339553lintols
menazons1945733menazons
menfolk1643883menfolk
menfolks1742903menfolks
menials94015683menials
menthols1347033menthols
mentors9314993mentors
metols84115773me_tols
mezzos1635053mezzo_s
mongols103310823mongols
nerols6914883ne_rols
obentos936703obento_s
pencels113610053pencels
pencils113011773pencils
pengos94612413pengo_s
pennons939713pennons
pensils92811593pensils
pentyls1236523pentyls
petrols92913083petrols
phenols1238103phen_ols
podzols1934683podzols
renails74917263renails
rentals74017473rentals
renvois1036503renvois
retools73411023retools
santols73513323santols
seizors16329013seizors
sendals81912263sendals
senhors103512133senhors
seniors73413623seniors
senors63620793sen_ors
sensors73514643sensors
snools65715883_snools
teazels16406893teazels
tenails73713923tenails
tendons8311473tendons
tenfold1145713tenfold
tenfolds1244413tenfolds
tenons62916603ten_ons
tenors63217753ten_ors
tensors72712373tensors
tenuous738483tenuous
vendors113510223vendors
venoms114211213ven_oms
venous93713193ven_ous
xenons132710483xen_ons

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.390458182.1
2DLD Change Limit1340271986.79619721.5
3Display Results1981980.0633142.9
 (SQL Overall)1786911987.24924650.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.