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

105 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
cadgers11471200(None) 
badgers114812651badgers
cadger105013911cadger_
cadges104716711cadge_s
cagers95624191ca_gers
codgers115113931codgers
adders84315702_adders
agers65027852_a_gers
aggers85817792_aggers
angers75222542_angers
augers73818702_augers
badger105415082badger_
badges103917372badge_s
baggers113915692baggers
bangers104020352bangers
budgers114314922budgers
cabers105023922ca_bers
cablers114416712cablers
cadavers1435892cadavers
cades85440732cad_e_s
cadets96316512cad_ets
cadge94018792cadge__
cadged114812342cadge_d
cadres94017932cadre_s
cager85229222ca_ger_
cages85936012ca_ge_s
cahiers123510672cahiers
calkers134414692calkers
callers94221962callers
cambers134017442cambers
campers134220292campers
cancers114018582cancers
candlers114214102candlers
caners84629202ca_ners
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
capers105428142ca_pers
cappers134419402cappers
carders104820352carders
careers95218782careers
carers85133962ca_rers
carpers114521252carpers
carters95327252carters
carvers124817542carvers
casters94729902casters
caters85336502ca_ters
causers94014792causers
cavers115026842ca_vers
ceders93817672ced_ers
changers144313202changers
chargers144011322chargers
ciders94620092cid_ers
clangers114312342clangers
codders114114452codders
coders95426982cod_ers
codger105814872codger_
congers104223232congers
cradlers11309202cradlers
cudgels1135332cudgels
cyders12398832cyd_ers
daggers103714912daggers
dangers94818212dangers
dodgers105213822dodgers
eagers74523682ea_gers
edgers84413922_edgers
faders105117462fad_ers
fadges114814032fadge_s
gadders103611502gadders
gadgets10348682gadgets
gagers84021332ga_gers
gaggers103413662gaggers
gangers94418602gangers
gaugers94211712gaugers
hangers113120812hangers
hedgers124310262hedgers
jaegers15307102jaegers
jagers144415722ja_gers
jaggers164012892jaggers
judgers16369042judgers
laagers83411252laagers
ladders94115172ladders
laders74927762lad_ers
ladlers84613572ladlers
lagers74826142la_gers
laggers94216242laggers
ledgers94912182ledgers
lodgers95113832lodgers
madders113513212madders
mangers103521262mangers
naggers93812652naggers
nudgers9479372nudgers
padders113312872padders
pagers94423252pa_gers
rangers83621042rangers
saggers94017082saggers
sangers84421942sangers
saugers83914052saugers
taggers93514192taggers
wadders123812442wadders
waders109120642wad_ers
wagers105122202wa_gers
waggers124613082waggers
yagers105114532ya_gers

Search took 5 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.436409841.7
2DLD Change Limit1076711053.90627565.5
3Display Results1051050.0303500.0
 (SQL Overall)1786911054.37240871.7
 
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.