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

124 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
tappers11341654(None) 
cappers134419401cappers
lappers113717461lappers
mappers133313781mappers
nappers114214861nappers
rappers113618441rappers
sappers113518901sappers
tampers113516741tampers
tapers84025811ta_pers
tapper104419611tapper_
tappets113610011tappets
tippers113414351tippers
toppers113914601toppers
trappers123711041trappers
yappers144012251yappers
zappers203911631zappers
apers76629132_a_pers
appears11308952_appears
appels104312792_appels
aspers86220312_aspers
boppers133911922boppers
campers134220292campers
capers105428142ca_pers
capper124421982capper_
carpers114521252carpers
clappers143310832clappers
coppers133519752coppers
crappers144011022crappers
cuppers133712212cuppers
dampers123915692dampers
dapper114016632dapper_
dippers123615182dippers
flappers15388382flappers
gapers94520472ga_pers
gaspers105014132gaspers
gawpers13448312gawpers
gippers123212082gippers
gyppers15235502gyppers
hampers143616952hampers
happens14359172happens
harpers124916202harpers
hoppers143115142hoppers
japers154616172ja_pers
jaspers164310462jaspers
kippers153211432kippers
knappers16315642knappers
lampers113817332lampers
lapper104319952lapper_
lappets11329122lappets
lapsers93911052lapsers
lippers113416442lippers
loppers113014102loppers
mapper124516092mapper_
moppers133412462moppers
napper103718282napper_
nappes104515622nappe_s
nippers113012622nippers
pampers133615932pampers
papers105125322pa_pers
paupers114311072paupers
peppers103311442peppers
poppers103414862poppers
rapers84327182ra_pers
rapiers95012872rapiers
rappees113611452rappees
rappels11448802rappels
rapper104621572rapper_
raspers94415922raspers
rippers114115032rippers
sapper103822352sapper_
sippers113117752sippers
slappers123710942slappers
snappers123510172snappers
stampers124211602stampers
staplers103111202staplers
steppers12289282steppers
stoppers123910592stoppers
strappers1346742strappers
suppers113314702suppers
swappers15358082swappers
tabers84621572ta_bers
tackers134319622tackers
taggers93514192taggers
tailers73720182tailers
takers103923742ta_kers
talers64628142ta_lers
talkers113513212talkers
tamers84224032ta_mers
tamper104618512tamper_
tankers113416912tankers
tanners74018392tanners
taper74829772ta_per_
taperers10269772taperers
tapes75838602ta_pe_s
tapirs84113172ta_pirs
tapped113820052tappe_d
tappet103820112tappe_t
tapsters10318802tapsters
tarpapers1344272tarpapers
tasters74225642tasters
taters64932202ta_ters
tatters74520482tatters
taupes8212672taupe_s
tawers94118602ta_wers
taxers134015282ta_xers
tempers113513012tempers
tipper103918412tipper_
tippets11339372tippets
tipplers12336352tipplers
topers85025322t_opers
topper103817602topper_
trampers123210392trampers
trapper113912802trapper_
trippers123210162trippers
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.376475242.0
2DLD Change Limit1076711242.96636301.8
3Display Results1241240.0462695.7
 (SQL Overall)1786911243.38852742.3
 
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.