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

148 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
cappers13441940(None) 
campers134220291campers
capers105428141ca_pers
capper124421981capper_
carpers114521251carpers
clappers143310831clappers
coppers133519751coppers
crappers144011021crappers
cuppers133712211cuppers
lappers113717461lappers
mappers133313781mappers
nappers114214861nappers
rappers113618441rappers
sappers113518901sappers
tappers113416541tappers
yappers144012251yappers
zappers203911631zappers
apers76629132_a_pers
appears11308952_appears
appels104312792_appels
aspers86220312_aspers
boppers133911922boppers
cabers105023922ca_bers
cablers114416712cablers
cadgers114712002cadgers
cagers95624192ca_gers
cahiers123510672cahiers
calipers1249442calipers
calkers134414692calkers
callers94221962callers
cambers134017442cambers
camper124722212camper_
cancers114018582cancers
caners84629202ca_ners
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
caper94831622ca_per_
caperers122611722caperers
capes95441922ca_pe_s
capless114312762capless
caplets114914522caplets
capped134721852cappe_d
captors113914982captors
carders104820352carders
careers95218782careers
carers85133962ca_rers
carpels115315462carpels
carper104923632carper_
carpets113915332carpets
carters95327262carters
carvers124817542carvers
casters94729902casters
caters85336502ca_ters
causers94014792causers
cavers115026842ca_vers
champers173311622champers
chapters154012132chapters
chippers173510882chippers
choppers174110462choppers
ciphers14379992ciphers
clampers143211892clampers
clapper134011862clapper_
claspers124410912claspers
clippers14368842clippers
coappears1542952coappears
coopers114019482coopers
copers104629842c_opers
copiers114215962copiers
copper124321892copper_
copperas14308572copperas
coppery16409392coppery
copters113621282copters
crapper133913192crapper_
croppers143311482croppers
cruppers14317322cruppers
cupper124313862cupper_
cyphers17316752cyphers
dampers123915692dampers
dapper114016632dapper_
dippers123615182dippers
flappers15388382flappers
gapers94520472ga_pers
gaspers105014132gaspers
gawpers13448312gawpers
gippers123212082gippers
gyppers15235502gyppers
hampers143616952hampers
happens14359172happens
harpers124916202harpers
hoppers143115142hoppers
japers154616172ja_pers
jaspers164310462jaspers
kippers153211432kippers
knappers16315642knappers
lampers113817332lampers
lapper104319952lapper_
lappets11329132lappets
lapsers93911052lapsers
lippers113416442lippers
loppers113014102loppers
mapper124516092mapper_
moppers133412462moppers
napper103718282napper_
nappes104515622nappe_s
nippers113012622nippers
pampers133615932pampers
papers105125322pa_pers
paupers114311072paupers
peppers103311442peppers
poppers103414862poppers
rapers84327182ra_pers
rapiers95012872rapiers
rappees113611452rappees
rappels11448802rappels
rapper104621572rapper_
raspers94415922raspers
rippers114115032rippers
sapper103822352sapper_
scalpers123710862scalpers
scampers143611032scampers
scarpers124712512scarpers
scaupers12378172scaupers
scrappers1545862scrappers
scuppers1446542scuppers
sippers113117752sippers
slappers123710952slappers
snappers123510172snappers
suppers113314702suppers
swappers15358082swappers
tampers113516742tampers
tapers84025812ta_pers
tapper104419612tapper_
tappets113610012tappets
tippers113414352tippers
toppers113914602toppers
trappers123711042trappers
uppers102912292_uppers
vampers143111622vampers
warpers123413582warpers
whappers18276742whappers
wrappers15306932wrappers
yapper133714512yapper_
yaupers12337662yaupers
yawpers15346852yawpers
zapper193414022zapper_
zippers203310382zippers

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.360496363.9
2DLD Change Limit1076711483.43631336.1
3Display Results1481480.0463217.4
 (SQL Overall)1786911483.84246509.9
 
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.