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

47 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
pericopes154787(None) 
pericope1447781pericope_
periscopes1646351periscopes
pericopae1565022pericopae
pericopal1545812pericopal
pericopic1745542pericopic
periscope1546412periscope_
aeroscopes1448013aeroscopes
bricoles122610303_bricoles
episcopes1545803episcopes
epitopes1246973_epitopes
helicopts1643803helicopts
liriopes1043883liri_opes
pedicles1338683pedic_les
pedicures1445263pedicures
percales12313803per_cales
percepts14247643per_cepts
perches143717953per_c_hes
percoids1339663per_coids
periapses1346053periapses
periapts1237273peri_apts
pericarps1544473pericarps
pericycles1943083pericycles
peridots1138323perido_ts
perigees1189503peri_gees
perigons11310083perigo_ns
perilous10310693perilo_us
perilunes1147163perilunes
perimorphs1953993perimorphs
periods10312243peri_o_ds
periques1937653peri_ques
periscopic1854423periscopic
perishes13313753peri_shes
peristomes1446053peristomes
peritonea1147303peritonea
perniones1148593perniones
petioles10311643peti_oles
porticoes1348253portico_es
precipes143212213p_recipes
precodes13711573p_recodes
prescores133912173prescores
prices104524543p_ric__es
prickles162511093p_rickles
princoxes2044083p_rincoxes
pyropes142210193pyr__opes
varicoses1446653varicoses
xeriscapes2152463xeriscapes

Search took 8 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 Limit148641476.76321978.6
3Display Results47470.0331424.2
 (SQL Overall)178691477.21924752.9
 
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.