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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
apostolates135419(None) 
apostolate1244511apostolate_
apostates1149162apost__ates
postulates1268962_postulates
apholates1449683ap__holates
apocopates1644953apo_copates
apostate1049853apost__ate_
apostilles1244043apostil_les
apostles1037753apost_l__es
expostulates2152353expostulates
ostomates1149343__ostomates
pastorates12410153_pastorates
postdates1248863_post_dates
postulate1169813_postulate_
postulated1377653_postulated
pustulates1276213_pustulates
absolutes1144524a_bs_olutes
acetylates1543854a_cetylates
acoelomates1554124acoelomates
aestivates13107364a_estivates
apholate13410474ap__holate_
apocopate1545034apo_copate_
apocopated1753554apo_copated
apoptoses1346444apopto__ses
aposiopeses1581684aposiopeses
apospories1446184apospo_ries
apostacies1445604apost_acies
apostasies1245584apost_asies
apostatise1255264apost__atise
apostatises1364584apostatises
apostatizes2264134apostatizes
apostille1144244apostil_le_
apostils1046774apostil___s
apostle937854apost_l__e_
apostolic1344554apostol__ic
apostolicities1861864apostolicities
apostrophes1854224apostrophes
approbates1645854ap_probates
astrolabes1253434a__strolabes
automates11412054a__utomates
capitulates1554424cap_itulates
chocolates1746784cho_colates
desolates10311794_des_olates
doctorates1346214_doctorates
episcopates1753084episcopates
epistolaries1452424epistolaries
expostulate2052454expostulate_
expostulated2252034expostulated
inosculates1345144inosculates
insolates9311274_ins_olates
isolates8613514__is_olates
osculates11109394__osculates
ostomate1049574__ostomate_
pastorales1247144_pastorales
pastorate11411184_pastorate_
percolates14410424_percolates
phenolates1547024_phenolates
pisolites1149384_pis_olites
pistoles102514724_pistol__es
populates132710674_po_pulates
posoles9314884_pos_ol__es
postages112815324_post__ages
postdate1139654_post_date_
postdated1346884_post_dated
postfaces1656274_post_faces
posthastes1546274_posthastes
postheats1447434_postheat_s
postholes14410454_posthol__es
postludes1244624_post_ludes
postulants1244964_postulants
postulator1246014_postulator
postulators1345254_postulators
prostates11314424prost__ates
prostrates12411994prost_rates
protonates12411694_protonates
pustulate1177244_pustulate_
pustulated1375544_pustulated
solates73523854___s_olates
sporulates1246484spo_rulates
stomates10313344___stomates
upstates10189644up_st__ates

Search took 10 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 Filter1786911488190.403443402.0
2DLD Change Limit148819818.87616766.4
3Display Results81810.0461760.9
 (SQL Overall)178691819.32519162.6
 
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.