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

157 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
pappose104741(None) 
appose10411991_appose
papoose1147511papoose
pappoose1143801pappoose
apposed1247852_apposed
apposer1147482_apposer
apposes11511472_apposes
oppose1039192_oppose
papooses1248052papooses
pappies103214822pappies
pappooses1243982pappooses
pappous1057462pappous
pappus9408372pappus_
papulose1244532papulose
propose112714842propose
purpose1137382purpose
suppose1137972suppose
trappose1245812trappose
adipose1036653adipose
aldose7311093_aldose
apos65433823_a_pos_
appease1137913appease
apple94517673_app_le
apples104315763_apples
apposers1236283_apposers
apposite12410013_apposite
apprise11310193apprise
approve14116603approve
apps86319693_app_s_
appulse1134673appulse
apse67725383_a_p_se
ariose64818723_ariose
arkose104911343_arkose
arose55832083_a_rose
baptise1139553baptise
caboose1138273caboose
callose9313653callose
campos125217953campos_
capos94826073ca_pos_
capote10315733ca_pote
caseose939163caseose
compose135716663compose
dapple1138853dapp_le
dapples1238993dapples
dapsone1038463dapsone
depose94215763_depose
dispose10312753dispose
expose1549523_expose
haploses1338853haploses
heptose1237493heptose
hippos13408433hippos_
impose103113043_impose
kappas144410363kappas_
lactose969473lactose
lamppost1443513lamppost
lanose6313593la_nose
lapse74917683la_p_se
leprose938543leprose
malposed1344563malposed
maltose939783maltose
mannose939243mannose
maypole1446383maypole
nappas105511613nappas_
nappe96114993napp__e
nappes104515623nappes_
nappie104112263napp_ie
nappies114613393nappies
narcose95910383narcose
opposed1236123_opposed
opposer1135773_opposer
opposes1149243_opposes
padrone102512073padrone
paise75028333pa__ise
palpate113213923palpate
palps94719563palp_s_
palpus104210283palpus_
pampas124913993pampas_
pandore10411853pandore
panpipe1034833panpipe
pantos85222743pantos_
papas94927493pa_pas_
papaws13419113papaws_
papers105125323papers_
papillose1393583papillose
papism122211513pa_pism
papist102618743pa_pist
pappi84810893papp__i
pappier103511593pappier
pappiest112611113pappiest
pappy114713803papp__y
paps86443453pa_p_s_
papulae11249353papulae
papule102212133pa_pule
papules112411573papules
parclose1247243parclose
pareos87023773pareos_
pargos95719043pargos_
parole84425253pa_role
parse75236993pa__rse
parvise124211693parvise
parvos116614753parvos_
pase65346863pa___se
paseos88015813paseos_
passe75525693pa__sse
pathos115516693pathos_
pathoses13412763pathoses
patios85221783patios_
pause75021833pa__use
pavise114714803pa_vise
pavisse12546813pavisse
pentose9311593pentose
peplos101211543peplos_
peploses1269463peploses
pepos96620083p_epos_
peptone11310763peptone
pilose84514233p_ilose
plumose1135963plumose
poppas93710713poppas_
poppies102816193poppies
popple92710983popp_le
popples103011873popples
porose84818743p_orose
porpoise1248073porpoise
pose66441733___pose
postpose1247643postpose
propone112716303propone
proposed132011073proposed
proposer121810633proposer
proposes122515973proposes
prose75835123__prose
puppies103212613puppies
purposed1335253purposed
purposes1237823purposes
ramose8314403ra_mose
rampole1139693rampole
rappee103618673rapp_ee
rappees113611453rappees
rapport11311223rapport
reoppose1245563reoppose
repose84121413_repose
sapote8314353sa_pote
saprobe1137333saprobe
scapose1147753scapose
spathose1345623spathose
supposed1345783supposed
supposer1245593supposer
supposes1238203supposes
tadpole1036143tadpole
talcose938133talcose
taphole1239773taphole
taphouse1346333taphouse
typhose1546693typhose
uprose82311483_uprose
vadose1037963va_dose
vamoose1235863vamoose
vamose1159283va_mose
zeppole2043493zeppole

Search took 10 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.250714764.0
2DLD Change Limit1340271578.67315453.4
3Display Results1571570.1101427.3
 (SQL Overall)1786911579.03319782.0
 
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.