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

106 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
bandagers133588(None) 
bandager1237701bandager_
bandages12310631bandage_s
badgers114812652ba_d_gers
bandage11311022bandage__
bandaged1337312bandage_d
banders104324562band__ers
bangers104020352ban__gers
bondages1237892bondage_s
managers112911002man_agers
tanagers9259002tan_agers
abandoners1342473abandoners
adages8412953_a_dage_s
angers75222543_an__gers
anlages82414113_anlage_s
badger105415083ba_d_ger_
badges103917373ba_d_ge_s
baggages1335443baggage_s
baggers113915693ba__ggers
bandaging1436063bandaging
bandanas11178573banda_nas
bandannas12163283bandannas
bandas95120543banda___s
bander93928223band__er_
bandies104124863band_ie_s
bandiness122310243bandiness
bandleaders1552713bandleaders
bandmasters1684183bandmasters
bandmates1447923bandmate_s
bandogs1138363bandog__s
bandoleers1343563bandoleers
bandoliers1344143bandoliers
bandores11311603bandore_s
bandwagons1751623bandwagons
banger94423643ban__ger_
banishers14258053banishers
banisters11189473banisters
banjaxes2443393banjaxe_s
bankers133919093ban__kers
banners94018713ban__ners
banterers112410013banterers
banters94623123ban__ters
barrages11711093barrage_s
barraters1138043barraters
bayadeers1541963bayadeers
benders104021063bend__ers
binders103920743bind__ers
bingers104519993bin__gers
blindages1343663blindage_s
bludgers12397853blud_gers
bondage1138253bondage__
bonders104120663bond__ers
branders114313093brand__ers
budgers114314923b_ud_gers
bundlers11399183bund_lers
cadavers1435893ca_davers
cadgers114712003ca_d_gers
candlers114214103cand_lers
canvasers14265363canvasers
damagers1237073da_magers
danders93921183dand__ers
dandlers103912053dand_lers
dangers94818213dan__gers
endangers1144943_endangers
engagers10246553_engagers
ganders93521703gand__ers
gangers94418603gan__gers
hanapers1346963han_apers
handaxes1938403handaxe_s
handers114224333hand__ers
handlers124014143hand_lers
handovers16136183handovers
hangers113120813han__gers
laagers83411253la__agers
landers84026213land__ers
landlers94312833land_lers
manager103413583man_ager_
manages103418963man_age_s
mandates11314093mandate_s
mandators1247873mandators
mangers103521263man__gers
massagers1245513massagers
onagers838103_on_agers
packagers18144683packagers
panderers12229153panderers
panders103423733pand__ers
rampagers1443863rampagers
rangers83621043ran__gers
ravagers1235583ra_vagers
salvagers1344693salvagers
sandbaggers1651923sandbaggers
sanders84025943sand__ers
sandpapers15113713sandpapers
sangers84421943san__gers
tanager83010953tan_ager_
tankages13217113tankage_s
tannages9228963tannage_s
unbandages1452043unbandage_s
vantages12119023vantage_s
vintagers13123903vintagers
wanderers13228483wanderers
wanders114221333wand__ers
wantages12109023wantage_s
windages1338263windage_s
yardages1336203yardage_s
zanders173015793zand__ers

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411066.84621712.1
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.31224438.0
 
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.