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

153 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
experted183805(None) 
exerted152210051ex_erted
expected2036741expected
exported1837131exported
exserted1636211exserted
everted112711852e_verted
excepted2055232excepted
excerpted2153872excerpted
excreted1846152excreted
exhorted1935012exhorted
expecter1936512expecter
expedited2044932expedited
expelled1895882expelled
expended19136542expended
expensed18126412expensed
expert15515352expert__
expertized2944712expertized
expertly2044702expertly
experts1659062expert_s
expiated18168522expiated
expired1736402expir_ed
exporter1737362exporter
exsected1835672exsected
extorted1636232extorted
adverted1336103adverted
alerted82512223_alerted
asperated1239313asperated
aspersed11428293aspersed
asserted957903asserted
averted112211613_averted
biparted1335133biparted
capered123014043caper_ed
coexerted1944763coex_erted
departed1238823departed
depermed1436453depermed
deported1249703deported
deserted101012203deserted
diverted13199583diverted
effected1744993effected
egested938123e_gested
ejected17297653e_jected
elected102812613e_lected
emerged11158213e_merged
emersed10138513e_mersed
emperies12314563emperies
enserfed1245193enserfed
entered82718883enter_ed
erected103213993e_rected
escorted1136703escorted
exacted1737303ex_acted
exalted1537393ex_alted
exapted1736073ex_apted
exasperated2153313exasperated
exceed1636173exce__ed
exceeded1943493exceeded
excelled18125703excelled
excerpter2063903excerpter
excessed1844943excessed
excited1737853ex_cited
excrete1667163excrete_
excreter1766123excreter
excretes1787573excretes
execrated1938353execrated
executed1835503executed
exempted2044143exempted
exert124624143ex_ert__
exerts133712293ex_ert_s
exhorter1845353exhorter
existed1538473ex_isted
exited144712523ex__ited
exonerated18106003exonerated
expanded19145163expanded
expect1758903expect__
expectedly2572533expectedly
expecters2045473expecters
expects1866883expect_s
expedite1847263expedite_
expediter1944593expediter
expedites1946163expedites
expellee17116093expellee
expeller17105793expeller
expend16247503expe__nd
expender18136843expender
expense16127873expense_
expenses17138373expenses
experting1938053experting
expertise1847933expertise
expertises1947103expertises
expertism2045433expertism
expertize2746583expertize
expertizes28106013expertizes
expertness1944823expertness
expiate16910593expiate_
expiates17810213expiates
expire1538023expir_e_
expirer1635993expir_er
expires1638683expir_es
expiries1747753expiries
explanted1944973explanted
exploded1944753exploded
exploited1944673exploited
explored1845083explored
export15412183export__
exporters1846253exporters
exports1647983export_s
exposed1737443exp_osed
exposited1945303exposited
expressed1946213expressed
expulsed1863613expulsed
expunged1942973expunged
expurgated2143063expurgated
exsert13414363exsert__
exserts1467013exsert_s
extended17135833extended
externe1438573externe_
externes1539833externes
extorter1546513extorter
exuberated2044493exuberated
exulted1536303ex_ulted
imparted13248063imparted
imported13308693imported
inserted92413053inserted
inverted122312163inverted
obverted1435103obverted
operated11512223_operated
papered122513173paper_ed
parted94228683__parted
pelted94617763__pelted
peppered1236133pepper_ed
perked134617693__perked
permed115217353__permed
perter84422283__perter
perverted1546103perverted
petted94121523__petted
pipetted1335263pipetted
ported94223243__ported
reexported2043323reexported
reoperated1348153reoperated
repeated113117443repeated
repented112614983repented
reperked15177793reperked
reported11312703reported
respected1438493respected
reverted122714713reverted
spirted103913073_spirted
sported104015433_sported
spurted103111973_spurted
supered10316123super_ed
tapered102612933taper_ed
tempered13248223temper_ed
tempested1444033tempested
unexpected2243113unexpected
unparted11310823unparted

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 Limit1461621536.61022112.3
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.09325192.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.