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

69 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
exercises184646(None) 
exercise1747061exercise_
exercised1944631exercised
exerciser1844111exerciser
exercisers1942851exercisers
exorcises1845691exorcises
cercises12410932_cercises
energises1047062energises
eternises9119452eternises
excises1638932ex__cises
exorcise1745932exorcise_
exorcised1944352exorcised
exorciser1843742exorciser
exorcisers1942552exorcisers
exorcisms2044862exorcisms
exorcists1845042exorcists
exorcizes2744252exorcizes
expertises1947102expertises
cerises94722253_cer_ises
dermises112512023_dermises
derrises93012783_derrises
ecesises1037023ece_sises
elegises9128823ele_gises
emeries91620023emer_i_es
emprises12311003empr_ises
energies9310783energi_es
energise947333energise_
energised1145183energised
energizes1945473energizes
eserines8413743eser_ines
eternise8119663eternise_
eternised10116273eternised
eternizes18118013eternizes
exarchies2145213exarchies
excides1738343ex__cides
excise1538553ex__cise_
excised1736673ex__cised
excites16310633ex__cites
excuses1638903ex__cuses
execrates1839563execrates
executes1736533exe_cutes
exegeses1644213exe_geses
exequies2444153exequi_es
exercising2044453exercising
exercycles2461743exercycles
exergues1644123exer_gues
exertions1639763exertions
exertive1839083exertive_
exocrines1845483exocrines
exodermises2152623exodermises
exorcism1945203exorcis_m
exorcist1746873exorcis_t
exorcize2644893exorcize_
exorcized2843753exorcized
expertise1847933expertise_
expertisms21114493expertisms
expertizes28106013expertizes
expresses1837863expresses
extermines1947783extermines
kermises14248313_kermises
mercies113817563_merci_es
merises93421423_mer_ises
precises123218333pre_cises
reraises8415643_reraises
rerises73525883_rer_ises
sherrises12156863sherrises
unexercised2152103unexercised
xeroses143612823_xer_oses
xeruses143010753_xer_uses

Search took 7 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 Filter1786911486410.1561145455.1
2DLD Change Limit148641696.40623203.4
3Display Results69690.0302300.0
 (SQL Overall)178691696.59227107.3
 
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.