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

144 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
sappers11351890(None) 
cappers134419401cappers
lappers113717461lappers
mappers133313781mappers
nappers114214861nappers
rappers113618441rappers
sapper103822351sapper_
sippers113117751sippers
slappers123710941slappers
snappers123510171snappers
suppers113314701suppers
swappers15358081swappers
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
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
sabers85224732sa_bers
sackers133820222sackers
saggers94017082saggers
sailers73822322sailers
sakers104125432sa_kers
salters73622252salters
salvers103916002salvers
samplers12299402samplers
sanders84025942sanders
sangers84421942sangers
sapiens9310172sapiens
sapless93313442sapless
sapors84118812sa_pors
sapours93610622sapours
sapped114422012sappe_d
sappier113613112sappier_
saucers93712132saucers
saugers83914052saugers
savers93825922sa_vers
sawers94620162sa_wers
sawyers13317532sawyers
sayers94221592sa_yers
scalpers123710862scalpers
scampers143611032scampers
scarpers124712512scarpers
scaupers12378172scaupers
scrappers1545862scrappers
scuppers1446542scuppers
shapers124016892shapers
sharpers133810942sharpers
shippers153012312shippers
shoppers153010762shoppers
simpers113014122simpers
sipper103920992sipper_
sippets113310182sippets
skippers16318202skippers
slapper113512462slapper_
slippers123711232slippers
slopers94213092slopers
snapper113512072snapper_
snipers93311772snipers
snippers12299722snippers
soapers93715922soapers
spacers113813872spacers
spaders104214472spaders
sparers94519612sparers
speers85019952s_peers
spiers84421742s_piers
stampers124211602stampers
staplers103111202staplers
steppers12289282steppers
stopers94217372stopers
stoppers123910592stoppers
strappers1346742strappers
supers84622402s_upers
supper104115432supper_
swampers15317472swampers
swapper14359702swapper_
syphers15317272syphers
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.390458182.1
2DLD Change Limit1076711443.28032826.5
3Display Results1441440.0463130.4
 (SQL Overall)1786911443.71648086.9
 
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.