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

159 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
papoose114751(None) 
papooses1248051papooses
pappoose1143801pappoose
pappose1047411pappose
appose10411992_appose
caboose1138272caboose
pappooses1243992pappooses
papulose1244532papulose
propose112714842propose
vamoose1235862vamoose
ahorse9311513_ahorse
aldose7311093_aldose
apocope1346033_apocope
apodoses1136653_apodoses
apods86316343_apods_
apogee9312563_apogee
apos65433823_ap_os_
appease1137913appease
apposed1247853_apposed
apposer1147483_apposer
apposes11511473_apposes
apprise11310193apprise
approve14116603approve
appulse1134673appulse
apse67725383_ap__se
ariose64818723_ariose
arkose104911343_arkose
arose55832083_a_rose
arouse65019983_arouse
baboos103517013baboos_
baptise1139553baptise
bazoos173212623bazoos_
cabooses1237863cabooses
callose9313663callose
capons104119503capons_
capos94826073cap_os_
capote10315733cap_ote
capotes11314643capotes
carouse9614423carouse
caseose939163caseose
choose115116143_choose
dapsone1038463dapsone
depose94215763dep_ose
espouse936403espouse
expose1549523exp_ose
gazoos163010223gazoos_
goose65925903__goose
haploses1338853haploses
heptose1237493heptose
impose103113053imp_ose
kapoks11347263kapoks_
karoos102415803karoos_
kazoos19259113kazoos_
lactose969493lactose
lanose6313593la_nose
lapse74917683lap__se
leprose938543leprose
loose56627683__loose
maltose939793maltose
mannose939243mannose
moose76327193__moose
narcose95910383narcose
noose55624063__noose
oppose1039193_oppose
padrone102512073padrone
paeons83915523paeons_
pagods105310193pagods_
paise75028333pa__ise
palooka1344503palooka
pandore10411853pandore
panoche1456383panoche
pantos85222743pantos_
papas94927493pap_as_
papaws13419113papaws_
papers105125323papers_
papillose1393603papillose
papism122211513pap_ism
papist102618753pap_ist
pappies103214833pappies
pappous1057463pappous
pappus9408373pappus_
paps86443453pap__s_
papulae11249353papulae
papule102212133pap_ule
papules112411573papules
parclose1247243parclose
pareos87023773pareos_
pargos95719043pargos_
parodos103011753parodos_
parole84425253pa_role
parolee94119643parolee
paroles95025883paroles
parols84722613parols_
parous84024163parous_
parse75236993pa__rse
parvise124211693parvise
parvos116614753parvos_
pase65346863pa___se
paseos88015813paseos_
passe75525693pa__sse
pathos115516693pathos_
pathoses13412773pathoses
patios85221783patios_
patois84319363patois_
patootie1046303patootie
pause75021833pa__use
pavise114714803pa_vise
pavisse12546813pavisse
payors114312643payors_
pentose9311593pentose
peplos101211543peplos_
peploses1269473peploses
pepos96620083pep_os_
peptone11310763peptone
pilose84514243p_ilose
plumose1135963plumose
poise75127893__poise
poos65949113__poos_
poove104514303__poove
porose84818743p_orose
porpoise1248083porpoise
pose66441733__p_ose
posse74722273__posse
propone112716303propone
proposed132011073proposed
proposer121810633proposer
proposes122515973proposes
prose75835123__prose
purpose1137383purpose
ramose8314403ra_mose
repose84121413rep_ose
roose56127093__roose
sapors84118813sapors_
sapote8314363sap_ote
sapotes9313943sapotes
saprobe1137333saprobe
scapose1147753scap_ose
spathose1345633spathose
spouse84112513_spouse
suppose1137973suppose
taboos83815433taboos_
talcose938143talcose
taphole1239773taphole
taphouse1346333taphouse
trappose1245813trappose
typhose1546693typhose
unloose797863unloose
uprose82311483_uprose
vadose1037963va_dose
vamoosed1443923vamoosed
vamooses1345523vamooses
vamose1159283va_mose
vaporise13209633vaporise
vapors113812693vapors_
wahoos122310593wahoos_
wazoos18288553wazoos_
yahoos12209243yahoos_
yapoks15346783yapoks_
yapons114411773yapons_

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271596.31321230.3
3Display Results1591590.0463456.5
 (SQL Overall)1786911596.74926476.7
 
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.