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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
ptoses8351467(None) 
poses74642761p_oses
proses84733471proses
ptosis83611821ptosis
pyoses114314301pyoses
apposes11511472apposes
atones65225772atones
broses86524402broses
choses115825132choses
closes85425592closes
coses76949492_coses
doses65938502_doses
eposes84418782eposes
eroses65327052eroses
ethoses10311762ethoses
gnoses76515162gnoses
gooses75723052gooses
heptoses1338372heptoses
hoses85443172_hoses
ketoses114912872ketoses
looses67328242looses
loses56742012_loses
lotoses73713642lotoses
mioses84318852mioses
mitoses9312182mitoses
myoses114013842myoses
nooses65623642nooses
noses55435642_noses
opposes1149242opposes
oses46641512__oses
ostoses71213552ostoses
parses85534702parses
pases75346502p_ases
passes86030472passes
pathoses13412772pathoses
pauses84621472pauses
peases85229472peases
peises84125042peises
pentoses10312892pentoses
peones83821042peones
perses85428062perses
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
potsies93019482potsies
poxes145325722p_oxes
prases84429022prases
prises84133172prises
probes104119452probes
proles84627202proles
prose75835122prose_
prosed94921092prosed
proser84223462proser
prosers94219642prosers
prosos85718552prosos
pross76529402pros_s
prosses94019512prosses
proves114322252proves
ptooey11346412ptooey
pulses83818662pulses
purses84826372purses
puses75532202p_uses
pusses84322842pusses
pyosis114012122pyosis
rooses65526232rooses
roses56445772_roses
stases64225562stases
stokes104821792stokes
stoles63927672stoles
stones65130032stones
stopes84525892stopes
stores65533662stores
stoss54316342stos_s
stoves93818922stoves
toes46956442_to_es
tokes95234972_tokes
toles55147132_toles
tomes76037382_tomes
tones56048662_tones
topes76941762_topes
tores55352672_tores
torses64727952_torses
toshes94520102_toshes
toss45637972_tos_s
tosses65225392_tosses
totes55139682_totes
touses64229672_touses
uptoss836092uptos_s
uptosses1043972uptosses

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.346516448.0
2DLD Change Limit825511072.43633887.9
3Display Results1071070.0462326.1
 (SQL Overall)1786911072.82863186.4
 
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.