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

75 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
bartending144491(None) 
attending11136372_attending
bartering122313642barte_ring
battening12268852batten_ing
portending1446192portending
amending12308913_a_mending
appending1536283_appending
ascending1336283_ascending
attendings12143523_attendings
banding114921413ba___nding
bantering122414233bante_ring
barbecuing1752323barbecuing
barbequing2462033barbequing
barbering14229683barbe_ring
barding113822893bar___ding
barehanding1873483barehanding
barkentine16103773barkentine
barning104320353bar__n_ing
barreling1238043barre_ling
barrelling1345453barrelling
bartend1038753bartend___
bartended1344663bartend_ed
bartender1244603bartend_er
bartenders1344223bartenders
bartends1136793bartend__s
bastinading1573553bastinading
battering122715143batte_ring
befriending1842213befriending
bending114420893b___ending
besteading1446033besteading
blending12249963b__lending
branding122513683b_r_anding
brazening2185183brazen_ing
breading123515463b_r_eading
breeding123411843b_r_eeding
burdening1335543burden_ing
burthening1643463burthen_ing
careening12310013careen_ing
cartoning12311113carton_ing
coattending1543543coattending
contending1449123contending
darkening1535683darken_ing
distending1348333distending
extending1835853_extending
fastening13268603fasten_ing
fattening13287833fatten_ing
forfending1844183forfending
friending1495553_friending
gardening1236513garden_ing
garlanding1344433garlanding
garmenting1445483garmenting
gartering112111573garte_ring
goaltending1451993goaltending
hardening1438023harden_ing
harkening1746923harken_ing
hastening13259483hasten_ing
heartening1446733hearten_ing
heartrending1762253heartrending
intending1139983_intending
latening9711493la_ten_ing
margenting1446153margenting
mistending1447953mistending
parenting12611583par_enting
partnering1345553partnering
patenting1248943pa_tenting
perpending1646683perpending
pretending1438613pretending
protending1446813protending
rattening10288763ratten_ing
rending93924263__r_ending
smartening1344993smarten_ing
subtending1445103subtending
tautening1035843tauten_ing
tending94419163___tending
trending103012833_tr_ending

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 Filter1786911406030.686260482.5
2DLD Change Limit140603756.26622439.0
3Display Results75750.0302500.0
 (SQL Overall)178691756.98225593.1
 
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.