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

176 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
purposes123782(None) 
purpose1137381purpose_
purposed1335251purposed
kurtoses12105622kurtoses
porpoises1348432porpoises
proposes122515972proposes
proses84733472p_r_oses
purples112712822purp_les
purports1265782purports
purposely1642922purposely
purpures1276142purpures
purses84826372pur__ses
repurposes1443172repurposes
supposes1238202supposes
adiposes1137173adiposes
airposts1045923airposts
apposes11511473_apposes
arkoses113910833_arkoses
aureoles838283aureoles
broses86524403_br_oses
burnooses1143433burnooses
burnouses1144853burnouses
burses84425513bur__ses
composes145017113composes
corpses113913803corp_ses
corpuses12310063corpuses
curses85328273cur__ses
deposes103117213_deposes
disposes11313813disposes
duresses939173duresses
eposes84418783__eposes
eroses65327053_er_oses
exposes1639963_exposes
fucoses12148303fu_coses
furanoses1244993furanoses
furores10310033fur_ores
gummoses1344743gummoses
imposes113213683_imposes
kurtosis1294403kurtosis
lordoses937143lordoses
lupuses936273lu_puses
morphoses1648123morphoses
murphies1536453murphies
narcoses103910543narcoses
neuroses8310153neur_oses
nurses63919353nur__ses
opposes1149243_opposes
outposts1037253outposts
papooses1248053papooses
pappooses1243983pappooses
pappose1047413pappose_
paradoses122510253paradoses
parcloses1347963parcloses
pareses94718873par_eses
parises94827183par_ises
paroles95025883par_oles
parses85534703par__ses
parvises133911913parvises
pathoses13412763pathoses
pentoses10312893pentoses
peploses1269463peploses
perfuses1358663perfuses
perses85428063per__ses
peruses94018163per_uses
pharoses13310313pharoses
phimoses1537193phimoses
phrases12711463phr_ases
porose84818743por_ose_
porpoise1248073porpoise_
porpoised1445443porpoised
poses74642763___poses
postposes1348183postposes
praises94121103p_raises
prases84429023p_r_ases
presses93523153p_resses
prises84133173p_r_ises
prisses94816713p_risses
probes104119453p_r_obes
proles84627203p_r_oles
propones122516963propones
propose112714843propose_
proposed132011073proposed
proposer121810633proposer
proposers13228523proposers
proptoses1349873proptoses
prose75835123p_r_ose_
prosed94921093p_r_osed
proser84223463p_r_oser
prosers94219643p_r_osers
prosos85718553p_r_osos
pross76529403p_r_os_s
prosses94019513p_rosses
proves114322253p_r_oves
prunuses1035123prunuses
psiloses1036433psiloses
ptoses83514673p__toses
pulpless12224953pulpless
pulpous1177013pulpo_us
pulses83818663pu__lses
pumpless14236373pumpless
pupates113311433pu_pates
puppies103212613pu_ppies
purchases1645633purchases
purees84721683pur__ees
pureness101110183pureness
purfles122511843pur_fles
purges94421763pur__ges
purifies13311923purifies
purines94420763pur_ines
purisms114110833pur_isms
purists94014073pur_ists
purities10316283purities
purlines103514053purlines
purloins1077033purloins
purple102712673purp_le_
purpled12299763purp_led
purpler11289263purp_ler
purplest12249123purplest
purport1159393purpo_rt
purported1443453purported
purposeful1751283purposeful
purposeless1551473purposeless
purposing1445233purposing
purposive1643223purposive
purpuras12105073purpuras
purpure1195993purpure_
purse76028893pur__se_
pursed95220883pur__sed
purser85020473pur__ser
pursers93916093pur__sers
pursues94111373pur_sues
puses75532203pu___ses
pusses84322843pu__sses
pycnoses1554973pycnoses
pyknoses1783573pyknoses
pyoses114314303p__yoses
pyranoses1445853pyranoses
pyrones123113303pyr_ones
pyropes142210193pyr_opes
pyrosis12411653pyr_osis
pyrroles1345453pyrroles
reposes94021263_reposes
repurpose1343133repurpose_
repurposed1542673repurposed
rooses65526233__rooses
roses56445773__r_oses
rumpuses1235163rumpuses
saroses73619333sar_oses
sorboses1038523sorboses
soroses73117483sor_oses
sucroses1039933sucroses
superposes1448933superposes
suppose1137973suppose_
supposed1345783supposed
supposer1245593supposer
supposers1344533supposers
surbases10310003surbases
surmises10310643surmises
surpass938283surpas_s
surpasses1145533surpasses
surpluses1155423surpluses
surprises1137433surprises
trioses75015653_trioses
triposes1039973triposes
turkoises1343633turkoises
unposed10711903_unposed
upases84112903_u_pases
upraises10188473upraises
uprises92012733upr_ises
uprose82311483upr_ose_
uprouses1037553uprouses
urases63723563_ur_ases
ureases74416723_ureases
uruses63616503_ur_uses
viroses10310533vir_oses
xeroses143612823xer_oses

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 Limit1461621766.84321359.3
3Display Results1761760.0632793.7
 (SQL Overall)1786911767.06225303.2
 
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.