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 “exercise” 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
exercise174706(None) 
exercised1944631exercised
exerciser1844111exerciser
exercises1846461exercises
exorcise1745931exorcise
energise947332energise
eternise8119662eternise
excise1538552ex__cise
exercisers1942852exercisers
exertive1839082exertive
exorcised1944362exorcised
exorciser1843742exorciser
exorcises1845692exorcises
exorcism1945202exorcism
exorcist1746872exorcist
exorcize2644892exorcize
expertise1847932expertise
cercis104614493_cercis_
cercises12410933_cercises
cerise84822043_cer_ise
coercive1545873coercive
eerie55228533e_er_i_e
elegise8139393ele_gise
emeries91620023emer_ies
emprise11310723empr_ise
energies9310783energies
energised1145193energised
energises1047063energises
energize1845563energize
eserine7415903eser_ine
eternised10116273eternised
eternises9119453eternises
eternize17118363eternize
exarchies2145213exarchies
exarchs19165193exarchs_
excide1638423ex__cide
excised1736673ex__cised
excises1638933ex__cises
excite15310883ex__cite
excuse1537423ex__cuse
execrate1739653execrate
execs14539723exe_c_s_
execute1636783exe_cute
exequies2444153exequies
exercisable2252773exercisable
exercising2044453exercising
exercycle2371833exercycle
exergue1544193exer_gue
exergues1644123exergues
exerting162211153exerting
exertion15310083exertion
exerts133712293exer_ts_
exocrine1745993exocrine
exorcisers1942553exorcisers
exorcisms2044863exorcisms
exorcists1845043exorcists
exorcized2843753exorcized
exorcizes2744253exorcizes
expertises1947103expertises
expertism2045433expertism
expertize2746583expertize
exsertile1644593exsertile
extermine1848283extermine
extrorse1544553extrorse
hexereis1894803hexereis_
mercies113817563_mercies
overwise141810253overwise
precise113518173pre_cise
quercine1964863quercine
reraise7316313_reraise
rerise64325633_rer_ise
unexercised2152103unexercised

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.423422437.4
2DLD Change Limit146162727.60619216.7
3Display Results72720.0332181.8
 (SQL Overall)178691728.06222164.6
 
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.