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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

257 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
jaspery1940525(None) 
japery18439141ja_pery
jasper154610381jasper_
jaspers164310461jaspers
apery106517902_a_pery
asper75520432_asper_
aspers86220312_aspers
gasper94515542gasper_
gaspers105014132gaspers
jaggery19336902jaggery
japer146218882ja_per_
japers154616172ja_pers
mastery124214322mastery
napery11489812na_pery
papery134812742pa_pery
rasper83917322rasper_
raspers94415912raspers
wastery134610992wastery
aery77231683_a__ery
ambery133811123_ambery
ampere10514413_ampere
aper66336233_a_per_
apers76629133_a_pers
artery9911453_artery
asker96418783_asker_
askers105915403_askers
aspect10612823_aspect
aspen75216093_aspe_n
aspens85013353_aspens
asperity1347223_asperity
asperse94210663_asperse
aspire8612123_aspire
assert64922573_assert
aster55434893_aster_
astern64815813_astern
asters65631603_asters
bakery155911003ba_kery
basely114412313bas_ely
baser74828923bas_er_
basher115123813basher_
bashers124820833bashers
basketry1743513basketry
baster85333593baster_
basters94930303basters
battery124911813battery
camper124722213camper_
campers134220283campers
cannery123610003cannery
caper94831623ca_per_
capers105428133ca_pers
capper124421983capper_
cappers134419403cappers
carper104923633carper_
carpers114521253carpers
casefy1436273cas_efy
casern84713313cas_ern
caster85232573caster_
casters94729893casters
cattery123811603cattery
cautery12349573cautery
clasper113811863clasper_
claspers124410913claspers
coopery143910273coopery
coppery16409393coppery
damper114117753damper_
dampers123915693dampers
dapper114016633dapper_
dapperly1643003dapperly
dasher104318983dasher_
dashers115016863dashers
daubery13396213daubery
drapery13387943drapery
dupery12378743_dupery
easier64218463easier_
easter65027983easter_
easterly11246643easterly
eastern74412533eastern
easters75125683easters
eatery95316353ea_tery
empery1348683_empery
faery116015483fa__ery
fakery16509263fa_kery
faster94625773faster_
fishery16397733fishery
foppery17385623foppery
gallery11468743gallery
gaper86125123ga_per_
gapers94520463ga_pers
gasher104320373gasher_
gasped104814293gaspe_d
gasser75017773gasser_
gassers84714633gassers
gaster75027353gaster_
gasters85624283gasters
gaudery1234743gaudery
gawper12499693gawper_
gawpers13448313gawpers
grapery13457953grapery
grasper10389783grasper_
graspers11338393graspers
hamper134518653hamper_
hampers143616943hampers
harper115018403harper_
harpers124916203harpers
hasped125014443haspe_d
hosiery13337183hosiery
jabber173713643jabber_
jabbers183610583jabbers
jacker194417583jacker_
jackers204214453jackers
jaeger14397193jaeger_
jaegers15307103jaegers
jager134318133ja_ger_
jagers144415723ja_gers
jaggary19304863jaggary
jagger154016003jagger_
jaggers164012893jaggers
jagghery2351803jagghery
jailer134316683jailer_
jailers144114043jailers
jammer174014133jammer_
jammers183710703jammers
jape134923423ja_pe__
japed156217633ja_pe_d
japes146322823ja_pe_s
jarvey19135403jarve_y
jauped16457903jaupe_d
jazzer21376503jazzer_
jazzers22324763jazzers
jeepers16399193jeepers
jester134319153jester_
jesters144118193jesters
jimper17389863jimper_
jittery17346443jittery
jobbery21366003jobbery
joinery17366593joinery
josher164312963josher_
joshers174111593joshers
jumper173612373jumper_
jumpers18399843jumpers
juster134617013juster_
justers143815723justers
kasher134915033kasher_
kashers143914023kashers
lampers113817333lampers
lamprey1434863lamprey
lapper104319953lapper_
lappers113717463lappers
lapser84113143lapser_
lapsers93911053lapsers
laser54633323las_er_
lasers64925703las_ers
lasher94824533lasher_
lashers104121833lashers
laster64830633laster_
lasters75627693lasters
lathery133911123lathery
lisper84114433lisper_
lispers94514323lispers
mapper124516093mapper_
mappers133313773mappers
maser75029973mas_er_
masers84623453mas_ers
masher114123203masher_
mashers124621053mashers
masker124416103masker_
maskers133913833maskers
masonry1244123masonry
master84831343master_
masterly13317653masterly
masters94628923masters
mattery123810713mattery
misery114113543mis_ery
mopery135210973_mopery
mystery15436523mystery
napper103718283napper_
nappers114214863nappers
oosperm1134883oosperm
osprey1134883_osprey
pamper124316663pamper_
pampero13328093pampero
pampers133615933pampers
paper95128663pa_per_
papers105125323pa_pers
passer84721033passer_
passerby1542503passerby
passers94717753passers
paster85734373paster_
pastern94415063pastern
pasters94531733pasters
pastry114913033pas_try
pauper103511943pauper_
paupers114311073paupers
peppery13286243peppery
plastery13279703plastery
popery134511703_popery
raper74932753ra_per_
rapers84327183ra_pers
rapper104621573rapper_
rappers113618443rappers
raser55633413ras_er_
rasers64526783ras_ers
rasher95024113rasher_
rashers104020903rashers
raspberry1641593raspberry
rasped94715203raspe_d
raspier93110633raspier_
raspy106511703rasp__y
raster64731443raster_
rasters74629023rasters
ropery114313873_ropery
rosery93813283ros_ery
sapper103822353sapper_
sappers113518893sappers
sperm93216013__sperm
sphery14318883__sphery
spiry105017353__spiry
spry96819123__sp_ry
tamper104618513tamper_
tampers113516743tampers
tannery10388653tannery
taper74829773ta_per_
tapers84025813ta_pers
tapper104419613tapper_
tappers113416543tappers
taster64930573taster_
tasters74225643tasters
tushery1335633tushery
vamper134212653vamper_
vampers143111623vampers
vapory14398763va_pory
vaster94521023vaster_
vesper1138083vesper_
vespers1239033vespers
wafery15398693wa_fery
waggery15276903waggery
warper114015583warper_
warpers123413583warpers
washer124720393washer_
washers134517523washers
waspier12259053waspier_
waspily1535513waspily
waspy135410993wasp__y
waster95228943waster_
wasters104026593wasters
wastry12388773was_try
watery123914493wa_tery
wavery154610053wa_very
whispery19284293whispery
yapper133714513yapper_
yappers144012253yappers
yauper11368543yauper_
yaupers12337663yaupers
yawper14437953yawper_
yawpers15346853yawpers
zapper193414023zapper_
zappers203911633zappers

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272576.95319276.1
3Display Results2572570.0932763.4
 (SQL Overall)1786912577.20224811.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.