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

61 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
bartender124460(None) 
bartended1344661bartended
bartenders1344221bartenders
attender935912_attender
barrener1038332barren_er
bartend1038752bartend__
bartends1136792bartend_s
barterer102711632barte_rer
battener10369392batten_er
amender10349613_a_mender
ascender1136733_ascender
attended1035763_attended
attendee946403_attendee
attenders1045273_attenders
bander93928223ba___nder
banterer102811773bante_rer
barbecuer1593203barbecuer
barkeeper1742933barkeeper
barnier93213673bar__nier
bartending1444913bartending
barter85525373bart___er
bartered113113013barte_red
barterers11269633barte_rers
battened11259573batten_ed
batteners11238163batten_ers
batterer102713213batte_rer
bender95223303b___ender
blender104613843b__lender
brander103915823b_r_ander
breeder103210043b_r_eeder
burdener1136143burden_er
bystander1542593bystander
calender1138273ca_lender
careener1039333careen_er
carpenter1346503carpenter
contender1239563contender
darkener1335993darken_er
darneder1033983darne_der
distender11167743distender
extender16146333_extender
fastener11227833fasten_er
fattener11268113fatten_er
gardener1037103garden_er
goaltender1252003goaltender
hardener1238883harden_er
harkener1537573harken_er
hastener11259133hasten_er
heartener1256763hearten_er
intender93310443_intender
larcener1036493larcen_er
lavender1235143la_vender
parcener1238473parcen_er
partner92811393part_n_er
portended1345643portended
pretender1246663pretender
rattener8238533ratten_er
render74024143__r_ender
surrender1074543surrender
tailender1044073tailender
tender74121843___tender
warrener1136913warren_er

Search took 9 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 Filter1786911486410.470380193.6
2DLD Change Limit148641617.54619698.0
3Display Results61610.0163812.5
 (SQL Overall)178691618.03222247.4
 
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.