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

67 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
phoresies144799(None) 
heresies11312692_heresies
phereses1348092pheres_es
pheresis1377632pheresi_s
phrensies1445742ph_rensies
poesies93217402p_o_esies
anorexies1645703anorexies
aphereses1466423apheres_es
apheresis1475333apheresi_s
aphorises14310003aphoris_es
choruses1339983chorus_es
chorusses1444883chorusses
foresees11311643_foresees
foresides1339703_foresides
geodesies1144593geodesies
homesites1448913_homesites
honesties1249913_honesties
horses94729343_hor_s_es
horsier103013243_hor_sier
horsiest112513263_hor_siest
horstes104516113_hor_stes
pareses94718883p_ares_es
paresis93315093p_aresi_s
peeresses1138473peeresses
pharisees1444633pharisees
pharoses13310313pharos_es
phoebes1435813pho_e_bes
phoenixes2143393pho_enixes
phonemes1546193phone_mes
phonemics1844933phonemics
phonetics1646733phonetics
phonies123717513pho__nies
phorates13413043phor_ates
phoresy1534653phores__y
phoronids1545663phoronids
phrases12711463ph_ras_es
phrensied1543373ph_rensied
phyleses1645183phyles_es
phylesis1645313phylesi_s
phylesises1843633phylesises
poornesses1236803poornesses
poperies12316793p_operies
popsies112816463p_o_psies
porgies103017003p_or_gies
porkies133416493p_or_kies
porkpies1636193p_orkpies
posies84431433p_o__sies
potsies93019483p_o_tsies
poussies1038113p_oussies
premies113823063p__remies
presides11414913p__resides
presses93523153p__resses
prexies163415003p__rexies
prioresses1245703prioresses
processes13310233processes
professes1437873professes
progenies12314123progenies
progresses1347493progresses
prophesies17107893prophesies
prossies101515223pro_ssies
prowesses1437193prowesses
putrefies1444663putrefies
shorelines1346143shorelines
shoreside1344733shoreside
shorties11414583shor_ties
threshes1437383th_reshes
whoresons1543863whoresons

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.423422437.4
2DLD Change Limit148641676.28323657.6
3Display Results67670.0302233.3
 (SQL Overall)178691676.73626527.8
 
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.