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

112 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
exsected183567(None) 
expected2036741expected
exserted1636211exserted
bisected1336202bisected
effected1744992effected
ejected17297652e_jected
elected102812612e_lected
erected103213992e_rected
exacted1737302ex_acted
excepted2055232excepted
executed1835502ex_ecuted
exerted152210052ex_erted
expecter1936512expecter
experted1838052experted
exsect1558502exsect__
exsects1655572exsect_s
resected112514742resected
absented1156613absented
advected1534533advected
affected1744793affected
assented957513assented
asserted957903asserted
axseed1456993axse__ed
caseated11310713caseated
defected15289973defected
deflected1635983deflected
dejected19307593dejected
deserted101012203deserted
detected12289733detected
directed1238233directed
disjected2086353disjected
dissected13108663dissected
easeled8159853ease_led
effecter1664773effecter
egested938123e_gested
electee92513243e_lectee
enacted10310643e_nacted
enserfed1245193enserfed
erecter93113393e_recter
eructed10228653e_ructed
escoted1038183e_scoted
estated83715573e_stated
everted112711853e_verted
evicted1337243e_victed
exacter1637403ex_acter
exalted1537393ex_alted
exapted1736073ex_apted
exceed1636173ex__ceed
exceeded1943493exceeded
excelled18125693excelled
excerpted2153873excerpted
excessed1844943excessed
excited1737853ex_cited
excreted1846153excreted
execrated1938353ex_ecrated
execute1636783ex_ecute_
executer1745313ex_ecuter
executes1736533ex_ecutes
exempted2044143exempted
exhorted1935013exhorted
existed1538473ex_isted
exited144712523ex__ited
expect1758903expect__
expectedly2572523expectedly
expecters2045473expecters
expects1866883expect_s
expedited2044933expedited
expelled1895863expelled
expended19136543expended
expensed18126413expensed
expiated18168523expiated
exported1837133exported
exscind1743753exs_cind
exsecant1794753exsecant
exsecting1935933exsecting
exsection1847493exsection
exsert13414363exsert__
exserts1467013exsert_s
exsiccated2242493exsiccated
extended17135833extended
extincted1943343extincted
extorted1636233extorted
extracted1946723extracted
exulted1536303ex_ulted
infected14229403infected
injected18226753injected
inserted92413053inserted
insetted9249023insetted
inspected1445403inspected
invected14258873invected
misacted1338673misacted
neglected1354693neglected
objected2043493objected
obtected1344553obtected
perfected1736633perfected
persecuted1543503persecuted
prosected14158633prosected
reejected1955093reejected
reelected1238313reelected
reerected1238613reerected
refected142311663refected
reflected1547983reflected
rejected182710113rejected
reseated93220263reseated
resented92716963resented
respected1438493respected
seated75131053__seated
selected1159783selected
suspected1444383suspected
trisected1244913trisected
unexpected2243113unexpected
unseated91317683unseated

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.1701051123.5
2DLD Change Limit1461621128.17317883.5
3Display Results1121120.0462434.8
 (SQL Overall)1786911128.38921300.6
 
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.