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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

152 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
bonders10412066(None) 
banders104324561banders
benders104021061benders
binders103920741binders
bonder95324781bonder_
boners84825431bon_ers
bonkers134015301bonkers
borders104317531borders
bounders114314101bounders
ponders103618841ponders
sonders83820711sonders
wonders113315991wonders
bander93928222bander_
bangers104020352bangers
bankers133919092bankers
banners94018712banners
banters94623112banters
beaders104120182beaders
bedders113513382bedders
bendees103913862bendees
bender95223302bender_
bidders114012302bidders
biders94822802b_iders
binder94422872binder_
bindery13459822bindery
biners85023632bin_ers
bingers104519982bingers
birders103913262birders
bladers104214682bladers
blenders115210992blenders
blinders113911142blinders
blonder104011942blonder_
blondes104213162blonde_s
blunders113911332blunders
boarders11408622boarders
boaters93419232boaters
bobbers103614282bobbers
bodes84935102bo_de_s
boilers93417062boilers
bolder94820932bolder_
bolters94017802bolters
bombers134512592bombers
bonded104719952bonde_d
bondless1148812bondless
bonds86126842bond__s
bonducs1235552bonducs
boner75133082bon_er_
bones76446532bon_e_s
bonier84321992bonier_
bonnes85621452bonne_s
bonnets94812802bonnets
bonzer175313672bonzer_
bonzes175116102bonze_s
boodlers113710742boodlers
boogers104514632boogers
bookers134016612bookers
boomers114115912boomers
boozers183912442boozers
boppers133911922boppers
bordels103911972bordels
border94419972border_
borers85122682bo_rers
bothers124317752bothers
boulders113010022boulders
bouncers12309352bouncers
bounder104215532bounder_
bowers115523702bo_wers
bowlders14306492bowlders
bowlers123715782bowlers
bowyers15438732bowyers
boxers155013482bo_xers
branders114313092branders
broiders114211182broiders
bronzers19296982bronzers
brooders112610232brooders
budders113812102budders
bundlers11399182bundlers
bunkers133715952bunkers
bunters94717112bunters
cinders104617752cinders
codders114114442codders
coders95426972co_ders
condors104018552condors
confers124120092confers
congers104223232congers
conkers133721042conkers
conners94023112conners
corders104520872corders
danders93921182danders
dodders105511792dodders
enders74324052_enders
fenders113717262fenders
finders113717872finders
fodders124010752fodders
folders113514392folders
fonder104120062fonder_
fondlers12338022fondlers
founders123911662founders
funders113813932funders
ganders93521702ganders
genders93616782genders
goners74420162gon_ers
handers114224332handers
hinders113718502hinders
holders113715902holders
honers94324972hon_ers
honkers143315232honkers
hounders123111702hounders
joinders16337202joinders
landers84026212landers
lenders84419642lenders
loaders83413412loaders
loners64225802lon_ers
longers84819532longers
menders103818802menders
minders103720112minders
molders103315552molders
mondes94322352monde_s
mongers104217272mongers
nodders94410252nodders
orders74315992_orders
panders103423732panders
pinders103720472pinders
polders103617372polders
ponder94521692ponder_
pounders113113262pounders
powders134111552powders
renders83821672renders
rondels82510052rondels
rounders92613682rounders
sanders84025942sanders
senders83022352senders
solders83517772solders
sonder73623522sonder_
sondes74922872sonde_s
sounders93214102sounders
sunders84120052sunders
tenders83719722tenders
tinders84219172tinders
toners64128002ton_ers
tongers84116012tongers
tonners73816402tonners
venders113717002venders
voiders11279822voiders
wanders114221332wanders
winders113721262winders
wonder103617812wonder_
wonners104312812wonners
yonder103214132yonder_
yonkers14379822yonkers
zanders173015792zanders
zoners155115992zon_ers

Search took 4 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 Filter1786911076710.1401276364.3
2DLD Change Limit1076711523.39031761.4
3Display Results1521520.0632412.7
 (SQL Overall)1786911523.59349733.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.