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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

60 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
claspers12441091(None) 
clampers143211891clampers
clappers143310831clappers
clashers134213991clashers
clasper113811861clasper_
classers104111831classers
aspers86220312__aspers
blasters104116142blasters
calipers1249442calipers
campers134220292c_ampers
capers105428142c_a_pers
cappers134419402c_appers
carpers114521252c_arpers
casters94729902c_asters
champers173311622champers
chasers123714922chas_ers
clabbers14359902clabbers
clackers163911702clackers
claimers12298742claimers
clambers144211292clambers
clammers143510692clammers
clamper134012992clamper_
clangers114312342clangers
clapper134011862clapper_
claquers19226202claquers
clasher124615512clasher_
clashes124017282clashe_s
clasped123610442claspe_d
clasps104512092clasp__s
classer93614612classer_
classes94717942classe_s
clatters103313912clatters
clavers124314902cla_vers
claviers1367102claviers
clawers123910972cla_wers
clippers14368842clippers
closers94415322clos_ers
clusters102912402clusters
clysters13227842clysters
coasters104317342coasters
crappers144011022crappers
crashers134013232crashers
crispers12309442crispers
flappers15388382flappers
flashers143912652flashers
gaspers105014132_gaspers
graspers11338402graspers
jaspers164310462_jaspers
lampers113817332_lampers
lappers113717462_lappers
lapsers93911052_lapsers
lasers64925702_las_ers
lashers104121832_lashers
lasters75627692_lasters
lispers94514322_lispers
plashers133813452plashers
plasters103518132plasters
raspers94415922_raspers
slappers123710952slappers
slashers113313612slashers

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 Filter1786911210590.576310227.4
2DLD Change Limit121059606.53318530.4
3Display Results60600.0134615.4
 (SQL Overall)178691607.12225090.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.