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

70 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
pharisee134759(None) 
pharisees1444631pharisees
parises94827182p_arises
pharoses13310312pharoses
aphorise1339983aphoris_e
aphorised1546363aphorised
aphorises14310003aphorises
appraisee1345973appraisee
arise56436433__aris_e
arisen65316793__arisen
arises65233803__arises
chaise114916413cha_is_e
chaises124317493cha_ises
chamise143612853chamis_e
chamises153513313chamises
charases131312753charases
charier124317903chari_er
chariest13315503chariest
charism14712203charis_m
charisma1576353charisma
charisms15710263charisms
frisee94217993__frisee
hardset113415833_hardset
harissa1035503_harissa
paise75028333p_a_is_e
pardee93922023p_ar_dee
pareses94718873p_areses
paries84742513p_ari_es
paris75145943p_aris__
parish115022353p_aris_h
parishes13314753p_arishes
parolee94119633p_arolee
parse75236993p_ar_s_e
parsec105914473p_ar_sec
parsed96323893p_ar_sed
parser84822373p_ar_ser
parses85534703p_ar_ses
parvise124211693p_arvis_e
parvises133911913p_arvises
passee84522023p_a_ssee
pavise114714803p_avis_e
paviser12489093p_aviser
pavises125315493p_avises
pavisse12546813p_avisse
perigee101113383p_erigee
pharisaic1644633pharisaic
pharos11312063pharos__
phase104617213pha__s_e
phased124011973pha__sed
phases114618403pha__ses
phasis114614923phasis__
phereses1348093phereses
phrase11109903ph_ras_e
phrased1387383ph_rased
phrases12711463ph_rases
phthises1645713phthises
polarise10513903polaris_e
polarised1269233polarised
polarises11514073polarises
praise84419413pra_is_e
praised104214813pra_ised
praiser93413943pra_iser
praises94121103pra_ises
praxises1739063praxises
prise74632613p__ris_e
prised94322203p__rised
prisere9310943p__risere
prises84133173p__rises
promisee122711333promisee
shamisen1344273shamisen

Search took 9 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 Limit146162708.10618031.3
3Display Results70700.0164375.0
 (SQL Overall)178691708.27821586.3
 
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.