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

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

98 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
pyrosises145758(None) 
promises122916762p_romises
prosses94019512p_ros_ses
prossies101515222p_rossies
pyrolizes2347232pyrolizes
pyrolyses1745582pyrolyses
pyronines1458322pyronines
pyrosis12411652pyrosi__s
sorosises947302sorosises
tyrosines1246862tyrosines
crosses94220793_cros_ses
cytosines1446223cytosines
drosses84513823_dros_ses
enosises8311003_enosises
gaposises1245523gaposises
grosses84517683_gros_ses
jarosites1647373jarosites
karosses1236493karos_ses
kenosises1345143kenosises
kerosines1357103kerosines
kurtosises1442693kurtosises
lyricises149810873lyricises
ostosises946233ostosises
paradises122513203paradises
parasites11313153parasites
parises94827183par__ises
parodies11313693parodi_es
parodists1248513parodists
parvises133911913par_vises
patronises1298433patronises
peroxides1947493peroxides
persists1049183per_sists
phylesises1843633phylesises
pirogies1139423pirogi_es
plosives1335893p_losives
poises84226543p__o_ises
porosities12411483porosities
porpoises1348433porpoises
posies84431433p__osi_es
posses85128803p__os_ses
praises94121103p_r_aises
praxises1739063p_raxises
precises123218333p_recises
premises123018273p_remises
presides11414913p_resides
presses93523153p_res_ses
previses133814283p_revises
prises84133173p_r__ises
prisses94816713p_ris_ses
prissies101712003p_rissies
proclises1339543p_roclises
profiles133211233p_rofiles
prolines102619693p_rolines
promines123018803p_romines
promise113415843p_romise_
promised133010873p_romised
promisee122711333p_romisee
promisees13246863p_romisees
promiser122510673p_romiser
promisers13268203p_romisers
propines122618933p_ropines
proposes122515973p_roposes
prosaisms1346273p_rosaisms
prosaists1157503p_rosaists
proses84733473p_ro__ses
prosier93817483p_rosi_er
prosiest10416523p_rosiest
prosiness11311683p_rosiness
prossie91812953p_rossie_
prosties101421193p_rosties
protases102115033p_rotases
protists10313363p_rotists
provides1439883p_rovides
provisoes1446653p_rovisoes
provisos1336913p_rovisos
proxies163014933p_roxi_es
pyloruses1443813pyloruses
pyoses114314303py_o__ses
pyosis114012123py_osi__s
pyranoses1445853pyranoses
pyranosides1753053pyranosides
pyridines1546473pyridines
pyrites12812203pyr__ites
pyrolize2248133pyrolize_
pyrolized2446123pyrolized
pyrolusites1652393pyrolusites
pyrolysis1745493pyrolysis
pyrolyzes2644293pyrolyzes
pyrones123113303pyro__nes
pyronine1349513pyronine_
pyropes142210193pyro__pes
pyrostats1444913pyrostats
pyroxenes2145453pyroxenes
synesises1245613synesises
tyrosinases1452723tyrosinases
tyrosine1147043tyrosine_
whoosises1543423whoosises
whosises1435333_whosises

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 Filter1786911486410.420425454.8
2DLD Change Limit148641986.25023782.6
3Display Results98980.0332969.7
 (SQL Overall)178691986.70326658.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.