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

162 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
epistles104778(None) 
epistle957891epistle_
epistler1044831epistler
epistlers1154111epistlers
epistyles1454141epistyles
apostles1037752apostles
bristles101510432bristles
enisles72312602enis_les
episodes1145912episodes
episomes1257302episomes
epistases1146322epistases
epistaxes1844452epistaxes
epistoler1143742epistoler
epistolers1243182epistolers
epistomes1346012epistomes
epistyle1364072epistyle_
gristles9189202gristles
istles62814982__istles
pestles93217692_pestles
pintles94118722_pintles
pistes85325632_pist_es
pistoles102514722_pistoles
spittles1038332spittles
thistles1198232thistles
whistles14108212whistles
aisles64721143_ais_les
anisoles81010123anisoles
apostle937853apostle_
belittles1143873belittles
bepimples1742303bepimples
bhisties1339003bhisties
bistres94017213_bistres
bristle91910103bristle_
bristled11187343bristled
brittles10178653brittles
bustles93816323_bustles
castles94917733_castles
cuittles1045903cuittles
edibles1048003edi_bles
ediles74016983edi__les
egises7312493egis__es
ekistics1485703ekistics
elites66027123eli_t_es
enisle63412093enis_le_
enisled82510223enis_led
enlistees954583enlistees
ensiles72714833e_nsiles
entitles8710663entitles
epibolies1345123epibolies
epicenes1249253epicenes
epicures1246513epicures
epicycles1843383epicycles
epidotes1147023epidotes
epigones1138023epigones
epilates10313503epilates
epimeres12117653epimeres
epinasties1243793epinasties
episcias1244883episcias
episcopes1545803episcopes
episode1056303episode_
episome1157813episome_
epistasies1244393epistasies
epistasis1144983epistasis
epistasy1343133epistasy
epistaxis1843613epistaxis
epistome1246263epistome
epitases1038933epitases
epithet12312463epi_thet
epithets1345763epi_thets
epitomes1257713epitomes
epitopes1246973epitopes
eposes84418783epos__es
eristics10610193eristics
eusteles838043e_usteles
evictees1344583evictees
evites94916473evi_t_es
exiles134816403exi__les
existed1538473exist_ed
exists134710913exist__s
exitless1534883exi_tless
expiates17810213expiat_es
gristle8169223gristle_
hustles103414173_hustles
isles54220563__is_les
istle52214713__istle_
ixtles13217063__ixtles
jostles143411143_jostles
justles143311433_justles
kirtles11309663_kirtles
kittles113012493_kittles
lisles63416283_lis_les
listees73416673_listees
listels74212433_listels
listless8269263_listless
littles73212783_littles
nestles73015463_nestles
opiates9312143opiat_es
pastels95215183_pastels
pastes85233913_past_es
pasties94529813_pasties
pastless102411203_pastless
peises84125043peis__es
peristyles1543863peristyles
pestle83215843_pestle_
pestled102711433_pestled
pettles93916483_pettles
piastres10249303_piastres
pickles153215443_pickles
piddles114314273_piddles
pieties9419223_pieties
piffles15368763_piffles
pigsties1139783_pigsties
piles74742613_pi__les
pilules9510623_pilules
pimples133012423_pimples
pinoles93418703_pinoles
pintle83818263_pintle_
pintoes95117713_pintoes
pishes114722103_pis_hes
pisses84525083_pis_ses
piste75824603_pist_e_
pistils93314303_pistils
pistole92414313_pistole_
pistoled11259593_pistoled
pistols93213983_pistols
pistons93016373_pistons
pistous92714383_pistous
pities83828083_pi_ties
pizzles17329273_pizzles
posoles9314883_posoles
posties93128813_posties
pottles93816983_pottles
pustules1038443_pustules
resistless1043173resistless
retitles83612593reti_tles
rustles73416413_rustles
skittles1245763skittles
spicules12219803spicules
spiles84227913spi__les
spindles112710353spindles
spinules10249333spinules
spites84127333spi_t_es
spittle937923spittle_
spitzes1849173spi_tzes
spurtles1037783spurtles
thistle10107803thistle_
titles63719923_ti_tles
tittles73413253_tittles
trestles83012553trestles
vittles103211113_vittles
waistless1235093waistless
warstles11368803warstles
whistle13107533whistle_
whistled1595783whistled
whistler1496313whistler
whistlers1595163whistlers
whittles1496673whittles
wintles103414983_wintles
wrastles11328933wrastles
wrestles113310063wrestles
wristlet1138643wristlet
wristlets1244473wristlets

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.1731032896.0
2DLD Change Limit1461621627.92018454.8
3Display Results1621620.1261285.7
 (SQL Overall)1786911628.21921741.2
 
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.