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

111 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
expecter193651(None) 
expected2036741expected
expecters2045471expecters
effecter1664772effecter
erecter93113392e_recter
exacter1637402ex_acter
executer1745312ex_ecuter
expect1758902expect__
expects1866882expect_s
expediter1944592expediter
expeller17105792expeller
expender18136842expender
experted1838052experted
exporter1737362exporter
exsected1835672exsected
oxpecker2341802oxpecker
respecter1347442respecter
specter113111732_specter
affecter1644523affecter
depicter1356853depicter
detecter11298733detecter
directer1137583directer
dopester1137253dopester
effected1744993effected
effecters1764323effecters
effector1644873effector
ejected17297653e_jected
ejector16378603e_jector
elected102812613e_lected
electee92513243e_lectee
elector93313263e_lector
enfetter1145353enfetter
erected103213993e_rected
erecters102611613e_recters
erector93513813e_rector
exacted1737303ex_acted
exacters1736773ex_acters
exactor1636633ex_actor
exalter1437563ex_alter
exceeder1843953exceeder
excepted2055253excepted
excerpter2063903excerpter
exciter1637753ex_citer
excreter1766123excreter
execute1636783ex_ecute_
executed1835503ex_ecuted
executers1854183ex_ecuters
executes1736533ex_ecutes
executor1744833ex_ecutor
exerted152210053ex_erted
exhorter1845353exhorter
expander18145803expander
expectant2045673expectant
expectedly2572533expectedly
expecting2146693expecting
expedite1847263expedite_
expedited2044933expedited
expediters2043463expediters
expedites1946163expedites
expeditor1943823expeditor
expelled1895883expelled
expellee17116093expellee
expellers18104753expellers
expended19136543expended
expenders19145963expenders
expense16127873expense_
expensed18126413expensed
expenses17138373expenses
expert15515353expert__
expertly2044703expertly
experts1659063expert_s
expiate16910593expiate_
expiated18168523expiated
expiates17810213expiates
expiator1747043expiator
expirer1635993exp_irer
exploder1844843exploder
exploiter1844583exploiter
explorer1744713explorer
exported1837133exported
exporters1846253exporters
exposer1637413exp_oser
expresser1845733expresser
expunger1843193expunger
exsect1558503exsect__
exsects1655573exsect_s
exserted1636213exserted
extender16146333extender
extorter1546513extorter
impacter14296573impacter
infecter13229153infecter
neglecter1263633neglecter
oxpeckers2441763oxpeckers
pecker144615363__pecker
pecten102711103__pecten
pelter83321623__pelter
perfecter1646043perfecter
perter84422283__perter
pester84827593__pester
peter74427593__pe_ter
petter83924773__petter
pewter114013673__pewter
rejecter17258943rejecter
repeater102615443repeater
repenter102813863repenter
respected1438493respected
respecters1445863respecters
specters122811063_specters
spectre11297773_spectre
spelter94113703_spelter
unexpected2243113unexpected

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 Limit1461621117.11020557.2
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.57623586.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.