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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
erepsin93739(None) 
erepsins1037451erepsins
pepsin10310852_pepsin
repin75324702_rep_in
resin54131052_re_sin
trypsin1245112trypsin
asepsis985903asepsis
creasing113314443creasing
creatin93618133creatin
creping122913653crep_ing
crepon1039943crep_on
cretin82917913cre_tin
dressing102810423dressing
ecesic10369223ece_sic
ecesis84611203ece_sis
egressing1146853egressing
egression1046193egression
elapsing1146713elapsing
emersion1047733emersion
emesis84712623eme_sis
emetin8613463eme_tin
eosin55220923__eosin
erasing8317963er_asing
erasion7311963er_asion
erecting112415063erecting
erection102115513erection
erethic1257723erethic
erosion7311123er_osion
erupting11218443erupting
eruption1047043eruption
etesian757853ete_sian
eupepsia1243353eupepsia
eversion1138713eversion
eyepoint1345793eyepoint
freesia1046323freesia
graplin1058443graplin
greasing102811393greasing
greisen856503greisen
gremlin1035563gremlin
herein93717793here__in
kremlin1344213kremlin
leptin82512333_leptin
opsin7613473__opsin
orpin73415533or_p_in
pepsine11310603_pepsine
pepsins11310433_pepsins
peregrin1146993peregrin
prepaid12310133prepaid
preplan1149953preplan
preppie1058093preppie
prepping12309763prepping
preprint12314183preprint
preps96220693preps__
pressing112516443pressing
raisin62716923_raisin
reagin74915533_reagin
reason62616333_reason
recoin84320293_recoin
redfin10310223_redfin
redskin1286023_redskin
regain74517763_regain
rein46040893_re__in
rejoin134012243_rejoin
remain85919863_remain
renin54830033_re_nin
rennin63914033_rennin
repaid94716323_repaid
repaint9318363_repaint
repair84011463_repair
repine85627813_rep_ine
repins84924313_rep_ins
replan83215823_replan
reposing111213803_reposing
reposit9315863_reposit
repping123314983_repping
reprint9318983_reprint
reps65937953_reps__
repugn946493_repugn
requin15310713_requin
resid64124093_re_sid
resign74212583_re_sign
resins64528773_re_sins
resiny94617363_re_siny
resit54241043_re_sit
retain64523283_retain
retsina74710603_retsina
reusing82516783_reusing
rewin85623963_re_win
rosin55325313_r_osin
seisin63715123_seisin
sepsis83011293_sepsis
seraphin1345953seraphin
serein63318463sere__in
skepsis1344253skepsis
steapsin1044713steapsin
stepson945673stepson
tiepin839343tiep_in
treason748763treason
trepan82511673trep_an
trephine1338933trephine
trepid9310083trep_id
tropin83316753trop_in
trypsins1344903trypsins

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271036.79619721.5
3Display Results1031030.0333121.2
 (SQL Overall)1786911037.23224708.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.