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

199 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
japeries1731146(None) 
aperies9423201_aperies
naperies10313901naperies
aeries64737782_a_eries
bakeries14312192bakeries
draperies1249192draperies
duperies11312812duperies
eateries8324312eateries
emperies12314562emperies
faeries104118992fa_eries
fakeries1559832fakeries
graperies1239612graperies
jaggeries18136972jaggeries
japers154616172japer__s
moperies12313872moperies
poperies12316792poperies
roperies10315762roperies
aerie54634603_a_erie_
aeried74221863_a_eried
aerier64823153_a_erier
aeriest73924053_a_eriest
amberies122514683amberies
ambries111614553_ambries
amerces1149853_amerces
amperes11313983amper_es
anergies9310453_anergies
apercus1136573_apercus
aperient10715153_aperient
aperients1178253_aperients
apers76629133_aper__s
apexes1539133_ape_xes
apiaries10312723_apiaries
aporias9315153_aporias
applies11311213_applies
apprise11310193_apprise
apprises12310963_apprises
apprizes2137793_apprizes
apres75426403_ap_r_es
arteries8321483arteries
asperges11318093asperges
asperses104111673asperses
batteries11615113batteries
bawdries14136843bawdries
beaneries11310903beaneries
boweries13312293boweries
braveries1439103braveries
calories102919553calories
canaries10318943canaries
canneries11313083canneries
capelins12311133capelins
capered123014043caper_ed
caperer113013403caper_er
caperers122611723caperers
capering132414963capering
capers105428143caper__s
caprices1439893cap_rices
capris10415083cap_ri_s
caries85147623ca__ries
carries94328013ca_rries
casefies1339213casefies
casernes103810753casernes
catteries11815523catteries
causeries11510643causeries
cauteries11615393cauteries
celeries10316313celeries
cooperies131113313cooperies
coteries10422703coteries
dairies84217733da_iries
dataries9314033dataries
dauberies1248033dauberies
daubries1136743daubries
deaneries10310833deaneries
doweries12411933doweries
draperied1344983draperied
emeries91620023_emeries
expiries1747753expiries
faerie93514683fa_erie_
fairies103516043fa_iries
fineries112416743fineries
flaneries1249563flaneries
fopperies1666013fopperies
gaieties9310183gaieties
galeres83514333galer_es
galleries10311703galleries
gantries91413783gantries
gapers94520473gaper__s
gauderies1147743gauderies
gayeties1236883gayeties
haeres94017033ha_er_es
harries103525493ha_rries
imageries1246783imageries
imperils1247713imperils
jackies202912623ja_ckies
jacqueries2843333jacqueries
jadeites1645823jadeites
jagers144415723jager__s
jaggaries18135743jaggaries
jaggheries2242423jaggheries
jaggies163311083ja_ggies
jalopies1786673jalopies
jammies183611293ja_mmies
japanizes2745163japanizes
japer146218883japer___
japery18439143japer__y
japes146322823jap___es
jaspers164310463jasper__s
javelins18277733javelins
jerids142810943j__erids
jerkies183411583j__erkies
jerries143817513j_erries
jewelries1943033jewelries
jobberies20115423jobberies
joineries1648103joineries
juries134120633j__uries
kauries113613193ka_uries
knaveries1645013knaveries
lamperses1345123lamperses
laterites9715053laterites
laterizes18513013laterizes
liveries11314373liveries
maderizes2148953maderizes
marries93825283ma_rries
masteries111018493masteries
materiel10311253materiel
materiels1147833materiels
miseries10320403miseries
nappies114613393nap_pies
niteries8318383niteries
orreries8310123orreries
panfries13149203panfries
pantries101817393pantries
papacies1439473papacies
papered122513163paper_ed
paperer113111903paper_er
paperers122410453paperers
paperiness1446133paperiness
papering132213313papering
paperless1345833paperless
papers105125323paper__s
papeteries1446553papeteries
pappies103214823pap_pies
paries84742513__paries
parries93925843pa_rries
pastries101517423pastries
pauperizes2344773pauperizes
peeries93623023_peeries
peres76246643__per_es
perils84121853__perils
peris75537073__peri_s
perries93226603__perries
perses85428063__perses
pineries102419083pineries
piperines131610693piperines
pries74339533__p_ries
queries16315873_queries
rapers84327183raper__s
rarefies1138993rarefies
rareripes1165353rareripes
reveries112518513reveries
roseries8317313roseries
ruderies9311333ruderies
safeties1139163safeties
salaries8319573salaries
sauries72821623sa_uries
savories11311273savories
sealeries9313133sealeries
series64540973__series
slaveries1249683slaveries
species11314133_species
superlies11314553superlies
tanneries9310423tanneries
tapelines1138463tapelines
tapered102612933taper_ed
taperer92511793taper_er
taperers10269773taperers
tapering112112503tapering
tapers84025813taper__s
tapestries1245403tapestries
tarries73324263ta_rries
tawdries12136083tawdries
tepefies1346893tepefies
traceries11312863traceries
updries10209083_updries
vagaries12310293vagaries
vaporise13209633vaporise
vaporises14209453vaporises
vaporizes23228523vaporizes
varies94330873va__ries
veeries102916893_veeries
veneries112815033veneries
vineries112716043vineries
voleries11313233voleries
waggeries14127463waggeries
wasteries121115343wasteries
wastries111212883wastries
waterier11312083waterier
wateriest12312233wateriest
wineries112316533wineries
yperites13310153_yperites

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621996.86021306.4
3Display Results1991990.0762618.4
 (SQL Overall)1786911997.09225196.1
 
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.