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

102 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
benzyls213367(None) 
benzols1836671benzols
benzoyls2242441benzoyls
benzyl2034161benzyl_
bendys12518382bendy_s
benomyls1542982benomyls
benzal1739642benzal_
benzins1838692benzins
benzol1756992benzol_
benzole1837132benzole
benzoles1936992benzoles
benzoyl2143362benzoyl_
benzylic2442282benzylic
beryls11107882be_ryls
bezels173712282be_zels
bezils1711310602be_zils
enzyms2063432_enzyms
pentyls1236522pentyls
adenyls1143923aden_yls
banzais1837163banzais
bedells10379363bedells
bedels94015273be_dels
beezers18349243beezers
befalls12349123befalls
befools1236433befools
befouls1236053befouls
begalls10319163begalls
behowls1534443behowls
belays114313853belay_s
bells76432163be__lls
bels66142493be___ls
benadryls1561443benadryls
benames112814603benames
benches143918603benches
bendays13327513bendays
bendees103913863bendees
benders104021063benders
bends85628973ben__ds
bendy115017253bendy__
benes75536233ben__es
bennes86019013ben_nes
bennets94712163bennets
bennies93917313bennies
bennis84314803ben_nis
benny105217363benny__
benomyl1443453benomyl_
bens65945703ben___s
benthos1238373benthos
bentos86218303ben_tos
bents76033693ben__ts
benumbs1333543benumbs
benzene1836343benzene
benzenes1946853benzenes
benzin1738933benz_in
benzine1839343benzine
benzines1938213benzines
benzoic2045033benzoic
benzoin1846263benzoin
benzoins1945573benzoins
beryl101211673be_ryl_
betels84515063be_tels
bethels1238533bethels
bevels113913983be_vels
bewails1277553bewails
beys913829553be__y_s
bezel165215173be_zel_
bezil163812883be_zil_
bonzes175116103bonz_es
brazils1867753brazils
bunyas11359433bun_yas
butyls1176753b_utyls
centals94317053centals
denials84114133denials
dentals83915393dentals
dentils84115583dentils
donzels1735393donzels
enols54718403_en_ols
enrols61213383_enrols
enzym1964393_enzy_m
enzyme2054343_enzyme
enzymes2164413_enzymes
ethyls1235903_ethyls
fennels10387903fennels
henrys12366103henry_s
hexyls1933433he_xyls
kennels11387193kennels
lentils73912973lentils
menials94015683menials
methyls1535453methyls
nonyls957853non_yls
pencels113610053pencels
pencils113011773pencils
pensils92811593pensils
pentyl1138813pentyl_
phenyls1534333phen_yls
renails74917263renails
rentals74017473rentals
sendals81912263sendals
teazels16406893teazels
tenails73713923tenails
tetryls1034643tetryls
vinyls12467003vin_yls

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271025.97022450.1
3Display Results1021020.0462217.4
 (SQL Overall)1786911026.43627764.3
 
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.