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

134 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
apostle93785(None) 
apostles1037751apostles
apostate1049852apostate
apostil947902apostil
apostille1144242apostille
apostils1046772apostils
epistle957892epistle
jostle13319862_jostle
pestle83215842_pestle
posole8314222_posole
postie84123962_postie
pottle84416102_pottle
adoptee1048413adoptee
aisle55223193a_is_le
amole75724593amo__le
amosite9313163amosite
ampoule11116603ampo_ule
anisole71010833anisole
anole55330383ano__le
aortae65115473a_ortae
apishly1535663apishly
aplite8316393aplit_e
apocope1346033apocope
apodal9289833apodal_
apogee9312563apo_gee
apollo837183apo_llo
apolune945283apolune
aport75432173aport__
apos65433823apos___
apostacy1544283apostacy
apostasy1344073apostasy
apostates1149163apostates
apostilles1244043apostilles
apostolate1244513apostolate
apostolic1344553apostolic
apothem1444643apo_them
apple94517673ap__ple
apposable1545603apposable
appose10411993appos__e
apposite12410013apposite
apse67725383ap_s__e
aptly105111813ap__tly
aristae7312533aristae
arose55832083aros__e
azole145118033azo__le
azote144416343azo_t_e
bottle84916073_bottle
bristle91910103bristle
bustle84015483_bustle
capote10315733capo_t_e
capsule1137343cap_sule
castle84918963_castle
chortle124210443chortle
costae85319683_costae
costly114012333_costly
dottle74212503_dottle
epistler1044833epistler
epistles1047783epistles
epistyle1364073epistyle
footle93914383_footle
ghostly14355103ghostly
gristle8169223gristle
hostel93914153_hostel
hostile10312553_hostile
hostler103411023_hostler
hostly124210863_hostly
hustle93113993_hustle
hypostyle2053663hypostyle
istle52214713__istle
jostled15267083_jostled
jostler14288223_jostler
jostles143411143_jostles
justle133211583_justle
moste75925083_most_e
mostly113110943_mostly
mottle84116053_mottle
nestle63013953_nestle
ostler63312193__ostler
paste74932953_past_e
pastel85918713_pastel
pastie85525523_pastie
pestled102711453_pestled
pestles93217693_pestles
pettle84116053_pettle
pintle83818263_pintle
piste75824603_pist_e
pistole92414313_pistole
pole65951303_po__le
poodle93112043_poodle
popple92710983_popple
portly114713403_portly
posable112212783_posable
pose66441733_pos__e
poshly1437723_poshly
posoles9314883_posoles
posse74722273_pos_se
post67953363_post__
postage103214853_postage
postal84317533_postal
postals93716383_postals
posted93722493_posted
posteen93512623_posteen
poster84129173_poster
posthole1339533_posthole
posties93128813_posties
postin83521033_postin
postlude1144543_postlude
postmen113110423_postmen
postop10511943_postop
posts75228783_post_s
posture9313253_posture
potsie83916033_potsie
pottles93816983_pottles
pozole1758913_pozole
prostie91617743prostie
prostyle13187273prostyle
pustule937683_pustule
riposte9269623ripost_e
rootle63214453_rootle
rustle63615413_rustle
sapote8314363sapo_t_e
spittle937923spittle
sporule937273sporule
spurtle937453spurtle
thistle10107803thistle
throstle1175703throstle
tootle62613813_tootle
trestle72611363trestle
urostyle11173953urostyle
warstle10328013warstle
whistle13107533whistle
whortle13335943whortle
wrastle10368993wrastle
wrestle10298843wrestle

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.440406115.9
2DLD Change Limit1340271347.06018984.0
3Display Results1341340.0502680.0
 (SQL Overall)1786911347.55023667.7
 
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.