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

102 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
nappers11421486(None) 
cappers134419401cappers
knappers16315641knappers
lappers113717461lappers
mappers133313781mappers
napper103718281napper_
nappes104515621nappe_s
nippers113012621nippers
rappers113618441rappers
sappers113518901sappers
snappers123510171snappers
tappers113416541tappers
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
knapper15387152knapper_
lampers113817332lampers
lapper104319952lapper_
lappets11329122lappets
lapsers93911052lapsers
lippers113416442lippers
loppers113014102loppers
mapper124516092mapper_
moppers133412462moppers
nabbers113710462nabbers
naggers93812652naggers
nailers73215892nailers
namers84517332na_mers
napery11489812na_pery
napes74828462na_pe_s
napless93110282napless
nappas105511612napp_as
nappe96114992nappe__
napped114218162nappe_d
nappier114411172nappier_
nappies114613392nappies
natters73718062natters
nipper103715712nipper_
pampers133615932pampers
papers105125322pa_pers
paupers114311072paupers
peppers103311442peppers
poppers103414862poppers
rapers84327182ra_pers
rapiers95012872rapiers
rappees113611452rappees
rappels11448802rappels
rapper104621572rapper_
raspers94415922raspers
rippers114115032rippers
sapper103822352sapper_
sippers113117752sippers
slappers123710942slappers
snapper113512072snapper_
snippers12299722snippers
suppers113314702suppers
swappers15358082swappers
tampers113516742tampers
tapers84025812ta_pers
tapper104419612tapper_
tappets113610012tappets
tippers113414352tippers
toppers113914602toppers
trappers123711042trappers
uppers102912292_uppers
vampers143111622vampers
warpers123413582warpers
whappers18276742whappers
wrappers15306932wrappers
yapper133714512yapper_
yaupers12337662yaupers
yawpers15346852yawpers
zapper193414022zapper_
zippers203310382zippers

Search took 7 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.263679433.5
2DLD Change Limit1076711025.98617987.1
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.27928458.5
 
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.