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

51 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
episcope144583(None) 
episcopes1545801episcopes
episcopal1553492episcopal
episcopate1653222episcopate
episode1056302epis_ode
episome1157812epis_ome
epistome1246262epistome
epitope1147052epi_tope
periscope1546412periscope
aeroscope1347683aeroscope
apocope1346033ap_ocope
bioscope1446483bioscope
endoscope1445653endoscope
epicene1148593epi_cene
epicure1136823epi_cure
epidiascope1861163epidiascope
epidote1037393epi_dote
epigone1057843epi_gone
episcia1145123episc_ia
episcias1244883episcias
episcopacy2151653episcopacy
episcopates1753083episcopates
episodes1145913epis_odes
episomes1257303epis_omes
epistle957893epis_tle
epistoler1143743epistoler
epistomes1346013epistomes
epistrophe1773083epistrophe
epistyle1364073epistyle
epitome1157743epi_tome
epitopes1246973epi_topes
escape103811663e__scape
fetoscope1655263fetoscope
miscode12310413_miscode
miscopy1636663_miscopy
myoscope1744993myoscope
nephoscope1954093nephoscope
otoscope1246433otoscope
pericope1447783pericope
periscopes1646353periscopes
piscine11610973_piscine
pisco96314983_pisco__
piscos105112593_pisco_s
pishoge1336693_pishoge
pistole92414313_pistole
scope94821483___scope
skiascope1752703skiascope
telescope1355063telescope
upslope1144173up_slope
viscose1237863_viscose
xeriscape2042603xeriscape

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 Filter1786911461620.1531167915.0
2DLD Change Limit146162517.11020557.2
3Display Results51510.0163187.5
 (SQL Overall)178691517.27924548.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.