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

91 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
excepted205523(None) 
excerpted2153871excerpted
accepted15105372accepted
exapted1736072ex_apted
exceed1636172exce__ed
exceeded1943492exceeded
excelled18125692excelled
except1797652except__
excepts1885202except_s
excerpter2063902excerpter
excessed1844942excessed
excited1737852exc_ited
excreted1846152excreted
executed1835502executed
exempted2044142exempted
exerted152210052ex_erted
expected2036742expected
experted1838052experted
exsected1835672exsected
exserted1636212exserted
incepted13177772incepted
accented13107773accented
acceptee14105713acceptee
accepter14144933accepter
discepted1547523discepted
effected1744993effected
egested938123e_gested
ejected17297653e_jected
elected102812613e_lected
emceed1136283emce__ed
encrypted1743183encrypted
encysted1444293encysted
erected103213993e_rected
erupted10207163e_rupted
escaped12388853escap_ed
escheated1546273escheated
escorted1136703escorted
escoted1038183esc_oted
everted112711853e_verted
exacted1737303ex_acted
exalted1537393ex_alted
exampled2043353exampled
excavated2243893excavated
exceeder1843953exceeder
exceeds1733843exce__eds
excepting2145873excepting
exception2046853exception
exceptive2345683exceptive
excerpt1845943excerpt__
excerpters2143183excerpters
excerptor2063653excerptor
excerpts1943743excerpt_s
excesses1736753excesses
excided1836203exc_ided
exciple1874683exciple_
exciples1964773exciples
excised1736673exc_ised
excite15310883exc_ite_
exciter1637753exc_iter
excites16310633exc_ites
excluded1943433excluded
excrete1667163excrete_
excreter1766123excreter
excretes1787573excretes
exculpated2243923exculpated
excused1736293exc_used
execrated1938353execrated
execute1636783execute_
executer1745313executer
executes1736533executes
exhorted1935013exhorted
existed1538473ex_isted
exited144712523ex__ited
expecter1936513expecter
expedited2044933expedited
expelled1895863expelled
expended19136543expended
expensed18126413expensed
expiated18168523expiated
exported1837133exported
extended17135833extended
extorted1636233extorted
exulted1536303ex_ulted
faceted13509563face_ted
facetted1445743facetted
incented112412543incented
reaccepted1743323reaccepted
receipted1445333receipted
scented102811883_scented
scepter1138353_scepter
sceptred1343653_sceptred

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.1601116818.8
2DLD Change Limit146162917.29620033.2
3Display Results91910.0461978.3
 (SQL Overall)178691917.50223819.1
 
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.