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

103 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
dancers10341309(None) 
cancers114018581cancers
dancer94817611dancer_
dances95120651dance_s
danders93921181danders
dangers94818211dangers
lancers93616641lancers
advancers1542992advancers
angers75222542_angers
banders104324562banders
bangers104020352bangers
bankers133919092bankers
banners94018712banners
banters94623112banters
cancels114113312cancels
cancer104220922cancer_
caners84629202can_ers
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
chancers154313492chancers
dabbers123813212dabbers
daces85030682da_ce_s
dackers143417042dackers
daggers103714912daggers
daikers124010312daikers
dammers123214272dammers
damners104112112damners
dampers123915692dampers
dance85223132dance__
danced105315252dance_d
dander811222992dander_
dandlers103912052dandlers
danger83722832danger_
danglers103610592danglers
danker114319662danker_
danseurs933432danseurs
darers75921872da_rers
darners83815772darners
darters84017602darters
dashers115016862dashers
daters74827372da_ters
daubers104610422daubers
daunders10278472daunders
daunters9329852daunters
deicers103612732deicers
deniers84515182deniers
dicers94720742d_icers
diners75525952din_ers
dingers94321382dingers
dinners83915442dinners
dunces95215752dunce_s
dunkers123512192dunkers
facers115519442fa_cers
fanciers13358082fanciers
fanners103914652fanners
farcers124713442farcers
fencers123810622fencers
ganders93521702ganders
gangers94418602gangers
glancers11408002glancers
hances115621282hance_s
handers114224332handers
hangers113120812hangers
hankers144218132hankers
lacers85225252la_cers
lancer84319972lancer_
lances84824102lance_s
lancets93411162lancets
lanciers10308542lanciers
landers84026212landers
lanners73618332lanners
macers105321272ma_cers
mangers103521262mangers
manners93417832manners
mincers113714852mincers
nances83618642nance_s
pacers105124542pa_cers
panders103423732panders
paniers94717332paniers
panners93621272panners
panzers184012012panzers
pincers113916502pincers
prancers123210332prancers
racers84725432ra_cers
rances84625442rance_s
ranchers133311792ranchers
rancors9811372rancors
rangers83621042rangers
rankers113217462rankers
ranters73323642ranters
sanders84025942sanders
sangers84421942sangers
saucers93712132saucers
tankers113416912tankers
tanners74018392tanners
vanners103612842vanners
wanders114221332wanders
wankers144514712wankers
wanters104420092wanters
wincers123415362wincers
zanders173015792zanders

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.373479064.3
2DLD Change Limit1076711033.20333615.7
3Display Results1031030.0333121.2
 (SQL Overall)1786911033.60949512.6
 
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.