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

185 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
pipers10431866(None) 
papers105125321papers
piers75926331pi_ers
pikers124717391pikers
piper96523191piper_
pipes96030141pipe_s
pipets105714771pipets
vipers114914531vipers
wipers115416081wipers
aiders74524632aiders
aimers84621912aimers
airers64922312airers
aivers94822322aivers
apers76629132_apers
aspers86220312aspers
biders94822802biders
biers76225222bi_ers
bikers124517552bikers
biners85023632biners
bipeds11458052bipeds
biters83925242biters
capers105428142capers
ciders94620092ciders
ciphers14379992ciphers
citers85022982citers
copers104629842copers
diapers104713912diapers
dicers94720742dicers
dikers114418792dikers
dimers94321092dimers
diners75525952diners
dippers123615182dippers
divers105024962divers
dopers95522482dopers
dupers94615602dupers
eiders74321362eiders
epimers11109492epimers
fibers114717522fibers
fifers125414922fifers
filers94623722filers
firers94922682firers
fivers124420922fivers
fixers165112982fixers
gapers94520472gapers
gibers95114662gibers
gippers123212082gippers
givers104817712givers
gripers104011462gripers
hiders104919652hiders
hikers135014352hikers
hirers94518062hirers
hopers114222972hopers
hypers144811912hypers
japers154616172japers
jibers155912882jibers
jivers164515642jivers
kiers95320092ki_ers
kippers153211432kippers
kiters105218592kiters
lepers84817322lepers
libers84721442libers
liers55130402li_ers
lifers95617842lifers
ligers75022042ligers
likers104620912likers
limpers113815222limpers
liners65428852liners
lippers113416442lippers
lispers94514322lispers
liters65429882liters
livers94927822livers
lopers84424142lopers
milers84625162milers
mimers105520182mimers
miners84126632miners
misers85025702misers
miters84328782miters
mixers154513562mixers
mopers104220372mopers
nippers113012622nippers
niters64624212niters
oilers64721192oilers
pacers105124542pacers
pagers94423252pagers
pampers133615932pampers
paper95128662paper_
papery134812742papery
parers85530742parers
paters84935832paters
paupers114311072paupers
pavers115021822pavers
pawers114818782pawers
payers114621822payers
peepers113713672peepers
peers75130272p_eers
peppers103311442peppers
peters86624592peters
pickers153718092pickers
piecers114112252piecers
pier66035292pi_er_
pies66949602pi_e_s
pigpens1235502pigpens
piker115622842piker_
pikes115031032pike_s
piles74742612pile_s
pileus84514942pileus
pilfers1238962pilfers
pincers113916502pincers
pinders103720472pinders
pinery115214292pinery
pines76048862pine_s
pingers104020742pingers
pinkers134118602pinkers
pinners93518602pinners
pipals104213642pipals
pipe86434432pipe__
piped105123162pipe_d
pipet95533322pipe_t
pipier104913982pipier_
pipits104713062pipits
pips85837132pip__s
pishers123815752pishers
pissers95014752pissers
pitiers93812652pitiers
pixels15478532pixels
pixes144323172pixe_s
pliers84715152pliers
plyers114912982plyers
poisers94214432poisers
pokers124617922pokers
polers84225642polers
popery134511702popery
popes95933812pope_s
poppers103414862poppers
posers84223972posers
powers113822322powers
pricers113915062pricers
priers84521192priers
primers114215672primers
prizers183911842prizers
propers113619032propers
pryers115012242pryers
pulers83820282pulers
pulpers114612282pulpers
pumpers133113672pumpers
rapers84327182rapers
ricers84120992ricers
riders74123902riders
rimers84522552rimers
ripens85012172ripens
riper74328402riper_
ripes75435772ripe_s
rippers114115032rippers
risers64624782risers
rivers94626542rivers
ropers84325902ropers
simpers113014122simpers
sipes76036952sipe_s
sippers113117752sippers
sivers95324152sivers
sizers155215812sizers
snipers93311772snipers
spicers113815552spicers
spiders103914412spiders
spiers84421742spi_ers
spikers135311992spikers
supers84622402supers
tapers84025812tapers
tiers55526522ti_ers
tigers75616512tigers
tilers63523502tilers
timers84420992timers
tippers113414352tippers
titers64526412titers
topers85025322topers
uppers102912292uppers
viers85621952vi_ers
viper105017302viper_
vivers124717362vivers
wiper105421292wiper_
wipes104827082wipe_s
wirers94617892wirers
wivers125320802wivers
yipes106017842yipe_s
zippers203310382zippers

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511852.51632810.4
3Display Results1851850.0464021.7
 (SQL Overall)1786911852.67266875.4
 
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.