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 “pyoses” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
pyoses11431430(None) 
myoses114013841myoses
poses74642761p_oses
proses84733471proses
ptoses83514671ptoses
pyosis114012121pyosis
apposes11511472apposes
broses86524402broses
choses115825122choses
closes85425592closes
coses76949492_coses
cyeses11510122cyeses
doses65938502_doses
eposes84418782eposes
eroses65327052eroses
eyases94513682eyases
gnoses76515162gnoses
gooses75723052gooses
hoses85443172_hoses
looses67328242looses
loses56742012_loses
lyases95211872lyases
lyses84518252ly_ses
mioses84318852mioses
myases113711552myases
mycoses1437722mycoses
myopes13419962myopes
myosis114012552myosis
nooses65623642nooses
noses55435642_noses
opposes1149242opposes
oses46641512__oses
parses85534702parses
pases75346502p_ases
passes86030472passes
pauses84621472pauses
peases85229472peases
peises84125042peises
peones83821042peones
perses85428062perses
peyotes1238482peyotes
phases114618402phases
phones114121212phones
physes14399782physes
pisses84525082pisses
pluses83618072pluses
poises84226542poises
pokes116133012p_okes
poles75351002p_oles
pomes94833932p_omes
pones74547042p_ones
pooves113914712pooves
popes95933812p_opes
pores75849032p_ores
pose66441732p_ose_
posed85828412p_osed
poser75128772p_oser
posers84223972p_osers
posies84431432p_osies
posse74722272p_osse
posses85128802posses
posts75228782p_osts
poxes145325722p_oxes
prases84429022prases
prises84133172prises
probes104119452probes
proles84627202proles
prose75835122prose_
prosed94921092prosed
proser84223462proser
prosers94219642prosers
prosos85718552prosos
pross76529402pros_s
prosses94019512prosses
proves114322252proves
ptosis83611822ptosis
pulses83818662pulses
purses84826372purses
puses75532202p_uses
pusses84322842pusses
pycnoses1554972pycnoses
pyes95528992py__es
pyknoses1783572pyknoses
pyres105523882py_res
pyrones123113302pyrones
pyropes142210192pyropes
pyrosis12411652pyrosis
pyxes175911402py_xes
pyxies18338292pyxies
rooses65526232rooses
roses56445772_roses
sycoses1249132sycoses
xyloses1746842xyloses
yeses85119322_yeses
yokes125223022_yokes
yores85031322_yores
yowes114926372_yowes
zygoses20436782zygoses
zymoses21608692zymoses

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit82551992.50033020.4
3Display Results99990.0303300.0
 (SQL Overall)178691992.64067686.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.