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

133 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
papooses124805(None) 
papoose1147511papoose_
pappooses1243991pappooses
apodoses1136652_apodoses
apposes11511472_apposes
cabooses1237862cabooses
haploses1338852haploses
pappoose1143802pappoose_
pappose1047412pappose_
pathoses13412772pathoses
peploses1269472peploses
proposes122515972proposes
vamooses1345522vamooses
abioses9311493_abioses
aldoses8311203_aldoses
apheses12610703_apheses
apoapses1244723_apoapses
apocopes1445993_apocopes
apodosis1146583_apodosis
apogees1037103_apogees
apoptoses1346443apoptoses
appeases1238663appeases
appose10411993_appose_
apposed1247853_apposed
apposer1147483_apposer
apposers1236283_apposers
apprises12310963apprises
approves15126833approves
appulses1234893appulses
apses76823913_ap__ses
arkoses113910833_arkoses
arouses74921293_arouses
baptises1238923baptises
bathoses13310463bathoses
caboose1138273caboose_
calloses10313393calloses
capiases1239253capiases
capotes11314643cap_otes
carouses10614503carouses
caseoses1039293caseoses
chooses125717423_chooses
dapsones1138383dapsones
deposes103117213dep_oses
diploses111110323diploses
eposes84418783_ep_oses
espouses1037303espouses
exposes1639963exp_oses
gaposis1038423gap_osis
gaposises1245523gaposises
gooses75723053__gooses
haplosis1347093haplosis
heptoses1338373heptoses
hypnoses1646633hypnoses
imposes113213683imp_oses
karosses1236493karosses
kyphoses2045283kyphoses
lactoses1039833lactoses
lapises93513463lap_ises
lapses85217693lap__ses
looses67328243__looses
maltoses1039863maltoses
mannoses1039083mannoses
narcoses103910543narcoses
nooses65623643__nooses
opposes1149243_opposes
padrones112711043padrones
palookas1443843palookas
pandores11312453pandores
panoches1548123panoches
papacies1439483papacies
papisms13238543pap_isms
papists112110453pap_ists
pappies103214833pap_pies
pappous1057463pappo_us
papules112411573pap_ules
papulose1244533papulose_
papyruses1643223papyruses
paradoses122510253paradoses
parcloses1347963parcloses
pareses94718883pa_reses
parises94827183pa_rises
parodies11313693parodies
parolees104313983parolees
paroles95025883pa_roles
parses85534703pa__rses
parvises133911913parvises
pases75346503pa___ses
passes86030473pa__sses
passuses1036773passuses
pastises103616053pastises
patooties1147183patooties
pauses84621473pa__uses
pavises125315493pa_vises
pavisses13397103pavisses
pentoses10312893pentoses
pepluses1287023pepluses
peptones12311033peptones
pharoses13310313pharoses
phimoses1537203phimoses
poises84226543__poises
pooves113914713__pooves
porpoises1348433porpoises
poses74642763__p_oses
posses85128803__posses
propones122516963propones
propose112714843propose_
proposed132011073proposed
proposer121810633proposer
proposers13228523proposers
proptoses1349873proptoses
proses84733473__proses
prosses94019513p_rosses
psiloses1036443psiloses
ptoses83514673__ptoses
purposes1237823purposes
pycnoses1554973pycnoses
pyknoses1783573pyknoses
pyoses114314303__pyoses
reposes94021263rep_oses
rooses65526233__rooses
sapotes9313943sap_otes
saprobes1237033saprobes
saroses73619333sa_roses
spouses92912813_spouses
supposes1238203supposes
tapholes1339623tapholes
taphouses1446553taphouses
tapises92914013tap_ises
unlooses8127293unlooses
vamoose1235863vamoose_
vamoosed1443923vamoosed
vamoses1239143va_moses
vaporises14209453vaporises

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.406440125.6
2DLD Change Limit1461621337.26620115.9
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.71823152.5
 
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.