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

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

92 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
benefitting175285(None) 
benefiting1644311benefi_ting
befitting15236622b__efitting
beneficing1843822benefi_cing
backfitting2353073backfitting
begetting13186583bege__tting
beneficiating2161453beneficiating
benefitted1642523benefitt_ed
besetting12268423bese__tting
bonefishing2052623bonefishing
reemitting1346633re_emitting
refitting132811123__refitting
unfitting1336423_un_fitting
babbitting1443004b_abbitting
babysitting1951614babysitting
bedeviling1743484bedevi_ling
bedevilling1852554bedevilling
beefing133911474be_ef___ing
beelining1236594be_eli_ning
beetling1139284be_e__tling
befittingly2051994b__efittingly
befretting1644794be_fretting
beknotting1782814be_knotting
belittling1343194b__elittling
bemisting1438074b__emisting
benediction1643324benediction
benedictions1753244benedictions
benefaction1852824benefaction
benefactions1952694benefactions
beneficent1754124benefi_cent
beneficial1753234benefi_cial
benefit1248074benefi_t___
benefited1544174benefi_t_ed
benefiter1443734benefi_t_er
benefiters1543344benefi_ters
benefits1345714benefi_t__s
bepainting15144884be_painting
besmutting1553354be_smutting
besotting12256874b__esotting
betting103921404b__e__tting
bevomiting1843104bevomi_ting
bitting103717294b____itting
bonefishings2151364bonefishings
brevetting1644334b_revetting
defatting1436104__defatting
demeriting1448684demeri_ting
demitting13239074__demitting
denervating1645924denervating
emitting112410354___emitting
enditing10311074_en_di_ting
enervating1488434_enervating
englutting1242724_englutting
enlisting1038344_en_listing
entitling1037104_en_titling
entwisting1443854_entwisting
eyeletting1442874_eyeletting
fitting113516564____fitting
formfitting2051894formfitting
generating12310394gene_rating
knitting13257024_kn__itting
leniting9312354len__i_ting
manumitting1652474manumitting
misfitting1645534_misfitting
netting84018764__ne__tting
outfitting1465824_outfitting
penetrating1447664penetrating
permitting1546304pe_rmitting
readmitting1544054readmitting
receipting1546754rece_ipting
redefeating1645334redefeating
redefecting1844374redefecting
redefining1545424redefi_ning
reediting11310954re_edi_ting
reenlisting1244674reenlisting
reknitting1584994re_knitting
reletting102713944rele__tting
remediating1547134remediating
remitting122412624__remitting
renesting102514704rene__sting
reoutfitting1651884reoutfitting
resetting102816294rese__tting
resitting103414874__resitting
resplitting1444944resplitting
retrofitting1653184retrofitting
revetting132912634reve__tting
rewetting132710444rewe__tting
telnetting1143884telne__tting
unknitting1542874_unknitting
unremitting1443214unremitting
unwitting1335584_un_witting
venenating1446014vene_nating
venerating14410054vene_rating

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit148819928.86016796.7
3Display Results92920.0462000.0
 (SQL Overall)178691929.34219127.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.