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 “benefits” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
benefits134571(None) 
benefit1248071benefit_
befits114711502b__efits
benedicts1443572benedicts
benefic1446042benefi_c
benefice1545002benefice
benefices1645062benefices
benefited1544172benefited
benefiter1443732benefiter
benefiters1543342benefiters
backfits19106953backfits
bandits103814793ban_dits
bankits133410153ban_kits
barefit1249723barefit_
beaneries11310903beaneries
bedevils1444373bedevils
bedsits1037563be_dsits
beedies10314203be_edies
beefier12329093be_efier
beefiest13269013be_efiest
beefily1535613be_efily
beefing133911473be_efing
beefs105618563be_ef__s
beets76131443be_e__ts
befit105222663b__efit_
begets96215523bege__ts
behests1235953behe_sts
beneath1236973bene_ath
benedick1743093benedick
benedicks1842563benedicks
benedict1346423benedict
beneficed1743533beneficed
benefiting1644313benefiting
benefitted1642523benefitted
benempt1346263benempt_
benes75536233bene___s
bennets94712163ben_nets
bennies93917313ben_nies
bennis84314803ben_ni_s
bents76033693ben___ts
benzins1838693ben_zins
benzoins1945573benzoins
bereft114317303beref_t_
berets85822523bere__ts
besets85718803bese__ts
bevomits1543463bevomits
binits85716673bin__its
bluefins1345113bluefins
bonefish1646283bonefish
bonesets1036843bonesets
confits122811423con_fits
deceits102810883dece_its
demerits11310763demerits
disbenefits1751333disbenefits
elegits8149343_elegits
enemies9313693_enemies
generics11118793generics
genesis82510823genesi_s
genetics11128613genetics
genets75716663gene__ts
henbits12177003hen_bits
peewits12105873pe_ewits
redefies12710163redefies
reedits8511743re_edits
reemits9611303re_emits
refits94017653__refits
renests74014213rene_sts
senecios1046303senecios
sennits73811283sen_nits
tenets65518953tene__ts
tepefies1346893tepefies
unfits93910293_un_fits
veneries112815033veneries

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162736.92021121.7
3Display Results73730.0332212.1
 (SQL Overall)178691737.10925135.9
 
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.