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

98 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
recovery1636621(None) 
recover124312621recover_
recovers133511121recovers
reconvert1449472reconvert
reconvey1655602reconve_y
recovered15166732recovered
recoverer14134972recoverer
remover124612272remover_
removers13449222removers
revery124014212re__very
bedcover1663563bedcover_
bedcovers1783563bedcovers
clovery15407403_clovery
covary1438743__covary
cover105430773__cover_
covers114627963__covers
covert114925503__covert
covey136121783__cove_y
decoder113712293decoder_
decoders122810413decoders
decoyer13348683decoyer_
decoyers14287713decoyers
delivery15286553delivery
discovery1845273discovery
every115215453_e__very
lechery15257643lec_hery
reaver94524733re_aver_
reavers108320743re_avers
recarry1245063rec_arry
receiver1337413receiver_
receivers1436363receivers
reciter94117263reciter_
reciters102613113reciters
reckoner1446063reckoner_
reckoners1545113reckoners
recode93618713recode__
recoded113115033recode_d
recodes102918633recode_s
recodify1743943recodify
recoiler103210493recoiler_
recoilers11318153recoilers
recolor978693recolor_
recolors1078813recolors
reconfer1337673reconfer_
reconfers1437213reconfers
reconvene1446493reconvene
reconverts1545723reconverts
reconveys1743533reconveys
recopy1339043reco__py
record96117423reco__rd
recorder11249633recorder_
recorders12187953recorders
recork126315483reco__rk
recoverers15133613recoverers
recoveries1547463recoveries
recovering1647373recovering
rectory123512723rec_tory
rediscovery2051933rediscovery
refinery14447193refinery
reiver95318293re_iver_
reivers105117083re_ivers
remotely1345623remotely
remoter94815973remoter_
remove116115573remove__
removed134611313remove_d
removedly1842833removedly
removes124514713remove_s
reposer93715333reposer_
reposers102911603reposers
repower12329883repower_
repowers13288533repowers
reprover13229203reprover_
reprovers14217773reprovers
resolver11339793resolver_
resolvers12297833resolvers
revelry1335693re__velry
reverb113912573re__verb
revere94621253re__vere
revers94529633re__vers
revert93529113re__vert
reviver134411373reviver_
revivers14389633revivers
revoker14419193revoker_
revokers15366753revokers
revolver14287713revolver_
revolvers15286113revolvers
rewove126420073rewove__
rewoven13557933rewove_n
rockery16439253roc_kery
rookery14398313r_ookery
ropery114313873r__opery
rosery93813283r__osery
rover85527373r__over_
rovers95423523r__overs
runover1034663runover_
runovers1134473runovers
uncover1239003uncover_
uncovers1336573uncovers

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.1531167915.0
2DLD Change Limit146162987.80018738.7
3Display Results98980.0462130.4
 (SQL Overall)178691987.99922339.2
 
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.