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

130 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
expected203674(None) 
expecter1936511expecter
experted1838051experted
exsected1835671exsected
effected1744992effected
ejected17297652e_jected
elected102812612e_lected
erected103213992e_rected
exacted1737302ex_acted
excepted2055232excepted
executed1835502ex_ecuted
exerted152210052ex_erted
expect1758902expect__
expectedly2572532expectedly
expecters2045472expecters
expects1866882expect_s
expedited2044932expedited
expelled1895872expelled
expended19136542expended
expensed18126412expensed
expiated18168522expiated
exported1837132exported
exserted1636212exserted
respected1438492respected
unexpected2243112unexpected
advected1534533advected
affected1744793affected
bisected1336203bisected
defected15289973defected
deflected1635983deflected
dejected19307593dejected
depicted1437743depicted
detected12289733detected
directed1238233directed
effecter1664773effecter
egested938123e_gested
electee92513243e_lectee
enacted10310643e_nacted
erecter93113393e_recter
eructed10228653e_ructed
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
expanded19145163expanded
expectant2045673expectant
expecting2146693expecting
expedite1847263expedite_
expediter1944593expediter
expedites1946163expedites
expellee17116093expellee
expeller17105783expeller
expend16247503expe__nd
expender18136843expender
expense16127873expense_
expenses17138373expenses
expert15515353expert__
expertized2944713expertized
expertly2044703expertly
experts1659063expert_s
expiate16910593expiate_
expiates17810213expiates
expired1736403exp_ired
explanted1944973explanted
explicated22106103explicated
exploded1944753exploded
exploited1944673exploited
explored1845083explored
exporter1737363exporter
exposed1737443exp_osed
exposited1945303exposited
expressed1946213expressed
expulsed1863613expulsed
expunged1942973expunged
exsect1558503exsect__
exsects1655573exsect_s
extended17135833extended
extincted1943343extincted
extorted1636233extorted
extracted1946723extracted
exulted1536303ex_ulted
henpecked2141893henpecked
impacted15286353impacted
infected14229403infected
injected18226753injected
inspected1445403inspected
invected14258883invected
neglected1354693neglected
objected2043493objected
obtected1344553obtected
oxpecker2341803oxpecker
peched144915343__peched
pecked155019103__pecked
pecten102711103__pecten
pelted94617763__pelted
perfected1736643perfected
petted94121523__petted
pipetted1335263pipetted
reejected1955093reejected
reelected1238313reelected
reerected1238613reerected
refected142311663refected
reflected1547983reflected
rejected182710113rejected
repeated113117443repeated
repented112614983repented
resected112514743resected
respecter1347443respecter
selected1159783selected
specced14266703_specced
specked16329013_specked
specter113111733_specter
suspected1444383suspected
tempested1444033tempested

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.420425454.8
2DLD Change Limit1461621307.05020732.2
3Display Results1301300.0602166.7
 (SQL Overall)1786911307.53023730.5
 
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.