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

227 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
benzol175699(None) 
benzal1739641benzal
benzole1837131benzole
benzols1836671benzols
benzoyl2143361benzoyl
benzyl2034161benzyl
befool1137712befool
bento75922952bento_
bentos86218302bentos
benzin1738932benzin
benzoic2045032benzoic
benzoin1846262benzoin
benzoles1936992benzoles
benzoyls2242442benzoyls
benzyls2133672benzyls
bezel165215172be_zel
bezil163812882be_zil
enol45823822_en_ol
enrol51014282_enrol
babool103012153babool
banal75925993ban_al
banco94019393banco_
bancos104713893bancos
bandog1038723bandog
banjo143812443banjo_
banjos15378893banjos
banzai1737653banzai
bazoo163815673b_azoo
beacon10511373beacon
beano75421553beano_
beanos85516513beanos
beanpole1244333beanpole
bebop11410793be_bop
beckon14309383beckon
beclog1136863beclog
bedel84219403be_del
bedell93610043bedell
bedroll1055553bedroll
beezer174010523beezer
befall114410643befall
befell11428713befell
befog1159013be_fog
befools1236433befools
befoul1137253befoul
begall92610723begall
begot84625953be_got
behold1247343be_hold
behoof1458683behoof
behowl1445533behowl
beknot1239763beknot
bel57148463be___l
bell66237183be__ll
bellow114213353bellow
belon73924113be_lon
below104617193be_low
ben56554923ben___
bename103316073bename
bench125619503ben_ch
bend76435263ben__d
benday123810813benday
bended105521233bended
bendee94121023bendee
bender95223303bender
bends85628973ben_ds
bendy115017253ben_dy
bendys12518383bendys
bene66439493ben__e
benes75536233ben_es
benign938313benign
benison937123benison
benne76521123ben_ne
bennes86019013bennes
bennet84823363bennet
benni74715363ben_ni
bennis84314803bennis
benny105217363ben_ny
benomyl1443453benomyl
bens65945703ben__s
bent67759913ben__t
benthal1247953benthal
benthon1237693benthon
benthos1238373benthos
bents76033693ben_ts
benumb1235773benumb
benzene1836343benzene
benzine1839343benzine
benzins1838693benzins
benzoate1944883benzoate
benzoins1945573benzoins
benzylic2442283benzylic
beryl101211673be_ryl
besnow1145713besnow
besom95716973be_som
besot76429713be_sot
bestow1149463bestow
betel74419903be_tel
bethel1169643bethel
beton76022063be_ton
betook12439603betook
bettor83612223bettor
bevel104517043be_vel
bevor101510813be_vor
bewail1189583bewail
bezels173712283be_zels
bezils1711310603be_zils
bezoar1736913be_zoar
binal75323823bin_al
bingo86020093bingo_
bingos95514793bingos
blazon1736763blazon
bonbon10310073bonbon
bongo85720943bongo_
bongos95316653bongos
bonze165119353bonz_e
bonzer175313673bonzer
bonzes175116103bonzes
borneol936823borneol
borzoi1736623borzoi
bozo156821413b_ozo_
bozos165216863b_ozos
brazil1779623brazil
bunco94616083bunco_
buncos104011593buncos
bunion83111313bunion
bunko115514513bunko_
bunkos124210323bunkos
censor84011293censor
cental84420963cental
cento76625173cento_
centos85920463centos
cineol8108203cineol
consol82614113consol
danazol1743253danazol
denial74720513denial
dental74319173dental
dentil74017883dentil
dewool1047403dewool
donzel1636313donzel
endow94510983_endow
enfold10137613_enfold
enjoy1545963_enjoy
enols54718403_en_ols
enow77819873_en_ow
enroll61110073_enroll
enrols61213383_enrols
ensoul638253_ensoul
entoil6912493_entoil
envoi878023_envoi
envoy1156723_envoy
enzym1964393_enzym
extol1247893_extol
fennel9429473fennel
genial74917613genial
genoa64315823gen_oa
genom83716843gen_om
genro64914033genro_
genros74211333genros
gentil74115123gentil
gentoo7311313gentoo
ginzo1539613ginzo_
gonzo15310243gonzo_
indol63714873_indol
kendo105113223kendo_
kendos114510663kendos
kennel10369223kennel
keno87926433ken_o_
kenos95220623ken_os
ketol95414003ke_tol
leno47331393len_o_
lenos56024863len_os
lentil64315393lentil
lento57223393lento_
lentos65317403lentos
lintol6369473lintol
menazon1846053menazon
menfolk1643883menfolk
menial84223033menial
meno66031363men_o_
mensal84615663mensal
mental84521603mental
menthol1236733menthol
mentor8414363mentor
metol75917813me_tol
mezzo1537433mezzo_
mezzos1635053mezzos
mongol94912533mongol
nerol51017813ne_rol
obento837893obento_
obentos936703obentos
penal75228373pen_al
pencel103812913pencel
pencil103712973pencil
pengo84317593pengo_
pengos94612413pengos
penial84120893penial
pennon8310643pennon
pensil83013333pensil
pentyl1138813pentyl
petrol82714063petrol
phenol1149253phen_ol
podzol1835083podzol
renail65020763renail
renal55929503ren_al
rental63922023rental
renvoi945863renvoi
retool63914483retool
santol64515243santol
seizor15428533seizor
sendal73314993sendal
senhor93010813senhor
senior63214053senior
senor53822803sen_or
sensor63813843sensor
snool55118643_snool
teazel15368543teazel
tenail64516113tenail
tendon7312033tendon
tenfold1145713tenfold
tenon53320513ten_on
tenor53620253ten_or
tensor63812673tensor
venal85523213ven_al
vendor10359803vendor
venial94218283venial
venom103914863ven_om
xenial133414903xenial
xenon122612453xen_on

Search took 7 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 Filter1786911127160.406440125.6
2DLD Change Limit1127162275.57620214.5
3Display Results2272270.0802837.5
 (SQL Overall)1786912276.06229477.2
 
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.