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

151 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
papyri133490(None) 
padri85815172pa_dri
paper95128662paper_
papers105125322papers
papery134812742papery
pappi84810892pap_pi
papyral1445772papyral
papyrian1544562papyrian
papyrine1546052papyrine
papyrus1444062papyrus
abri65522213_a_bri
acari75020283_acari
apart74330673_apart
aper66336233_aper_
apers76629133_apers
apery106517903_apery
aporia8315863_aporia
aport75432173_aport
caper94831623caper_
capers105428143capers
capric12411803cap_ric
capris10415083cap_ris
gaper86125123gaper_
gapers94520473gapers
gapy106320913gapy__
gyri85415153__gyri
japer146218883japer_
japers154616173japers
japery18439143japery
kauri93811853ka_uri
laari54415713la_ari
lampyrid1642903lampyrid
lari45839153la__ri
napery11489813napery
pacer96131613pacer_
pacers105124543pacers
pacy115328683pacy__
padi76331783pa__di
padre86018163pa_dre
pager84728203pager_
pagers94423253pagers
pagurid11105443pagurid
pair66031513pa_ir_
pairs75325833pa_irs
pakora1247283pakora
paler75436933paler_
palmyra1444143palmyra
palpi95414553pa_lpi
paltry114910403paltry
paly95835533paly__
pamper124316663pamper_
pampero13328093pampero
pampers133615933pampers
panfry14456413panfry
panini8314273panini
pantry115014103pantry
pap76758403pap___
papa85827143pap__a
papacy1547493papacy
papain10313793papain
papal95820673pap_al
papas94927493pap_as
papaw125112493pap_aw
papaws13419113papaws
papaya1337503papaya
papayan1445303papayan
papayas1437273papayas
papered122513173papered
paperer113111903paperer
papering132213313papering
papism122211513papism
papist102618753papist
pappus9408373pappus
pappy114713803pap_py
paprica1337003pap_rica
paprika1544003pap_rika
paps86443453pap__s
papula103011113papula
papule102212133papule
par57467023pa__r_
para65242173pa__ra
pard76441323pa__rd
pardi85723953pa_rdi
pare66760843pa__re
parer75839903parer_
parers85530743parers
paris75145943pa__ris
park105237493pa__rk
parr65731153pa__rr
parrs75928673pa_rrs
parry105323753pa_rry
pars67560793pa__rs
part65967463pa__rt
parura8310583parura
parure8312523parure
pastry114913033pastry
pater74740723pater_
paters84935833paters
paty95234563paty__
pauper103511943pauper_
paupers114311073paupers
paver104225833paver_
pavers115021823pavers
pawer104422973pawer_
pawers114818783pawers
pay88461183pa_y__
payed115925933pa_yed
payee105524723pa_yee
payer105125723pa_yer
payers114621823payers
paynim1337363pa_ynim
payor105413843pa_yor
payors114312643payors
pays95940223pa_y_s
peri65636973__peri
piper96523193piper_
pipers104318663pipers
pipy115421513pipy__
platypi1442753platypi
polypi13458593polypi
poori74816233p_oori
popery134511703popery
puparia1147353puparia
puri65931443__puri
pylori1147163pylori
pyre94925553__pyre
pyric123815073__pyric
pyro96019393__pyro
raper74932753raper_
rapers84327183rapers
rapini84714683rapini
safari91110223safari
sapor75119253sapor_
sapors84118813sapors
sari45444043sa__ri
satori6415843satori
satyr848483satyr_
satyric1237503satyric
satyrid1137233satyrid
satyrs937963satyrs
spagyric1642053spagyric
tamari8313413tamari
taper74829773taper_
tapers84025813tapers
tapir75917063tapir_
tapirs84113173tapirs
uakari1046863uakari
vapor104013093vapor_
vapors113812693vapors
vapory14398763vapory
wapiti1138363wapiti

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 Filter1786911127160.376475242.0
2DLD Change Limit1127161515.86019234.8
3Display Results1511510.0463282.6
 (SQL Overall)1786911516.28228444.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.