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

72 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
approved1611507(None) 
approve14116601approve_
approver15105301approver
approves15126831approves
apposed1247852app_osed
apprised1337712apprised
apprized2236542apprized
approval1544482approval
approvers16104912approvers
aproned10311502a_proned
improved1644772improved
proved125016032__proved
reapproved1842742reapproved
reproved14199482reproved
unapproved1842382unapproved
unproved1457532unproved
alcoved1375623a_lcoved
appalled1344813appalled
appareled1442893appareled
appealed1335603appealed
appeared1336143appeared
appeased1335793appeased
appended1435483appended
applied1247483app_lied
appose10411993app_ose_
apposer1147483app_oser
apposes11511473app_oses
appraised1445593appraised
apprehend1743103apprehend
appressed1445943appressed
apprise11310193apprise_
appriser1246783appriser
apprises12310963apprises
apprize2038183apprize_
apprizer2145463apprizer
apprizes2137793apprizes
approach1743763approach
approached2062363approached
approbated1744763approbated
approvals1643623approvals
approving1745053approving
arrived11127353a_rrived
arrowed1148133a_rrowed
depraved1535543depraved
deprived1546463deprived
disapproved2062563disapproved
disproved16147343disproved
droved114611643__droved
groved114413703__groved
improve1435963improve_
improver1545243improver
improves1536123improves
opposed1236123opp_osed
paroled104217633_paroled
parroted1158853parroted
preapproved1851763preapproved
probed114114823__probed
prosed94921103__prosed
prove104823193__prove_
proven114314773__proven
prover113819723__prover
proves114322253__proves
reapprove1643183reapprove_
reapproves1743063reapproves
reprobed13228753reprobed
reprove122911073reprove_
reprover13229203reprover
reproves132011473reproves
roved95323553___roved
unprobed1366973unprobed
unproven1365463unproven
uppropped1242473uppropped

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 Limit146162727.48619524.7
3Display Results72720.0302400.0
 (SQL Overall)178691727.93622516.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.