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 “excitements” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
excitements225428(None) 
excitement2154871excitement_
excrements2146982exc_rements
incitements1556292incitements
encasements1547453encasements
enticements1598163enticements
entitlements1455103entitlements
escapements1744823escapements
excipients2152723exci_pients
excisemen2052863excisemen__
excitants1864393excit__ants
excrement2048063exc_rement_
incitement1447133incitement_
abatements1446354_abatements
accruements1753774accruements
advisements1754824advisements
alinements1247134_alinements
battements1455814_battements
beguilements17113894beguilements
casements1348584__casements
cements112714224__c__ements
cerements13411454__cerements
debatements1656044debatements
debridements1853894debridements
decrements1549384dec_rements
defilements1747074defilements
definements1747114definements
denotements1446864denotements
despisements1785164despisements
devotements1745614devotements
easements11410334e__asements
effacements2154874effacements
ejectments2144054eject_ments
elements10312174e___lements
eloinments1245994eloi_nments
elopements14146364e_lopements
embitterments19102004embitterments
emblements1647794e_mblements
enactments1446524enact_ments
encampments19103934encampments
encasement1448704encasement_
encashments1875064encashments
encipherments2262014encipherments
encirclements19133234encirclements
encystments1853624encystments
engagements1546504engagements
enlacements1546994enlacements
enlistments1345664enlistments
enrichments1855334enrichments
enticement1489604enticement_
entitlement1355814entitlement_
equipments2344024equi_pments
escapement1645864escapement_
escarpments1753444escarpments
evolvements1953744evolvements
excimers1944704exci__me_rs
excipient2044484exci_pient_
exciseman2051664exciseman__
excitant1777354excit__ant_
exciters1736324excit__e_rs
excites16310634excit__e__s
excitons1746044excit__on_s
excremental2253704exc_remental
existents1644984ex_i_stents
experiments2255914experiments
extents142610174ex__t__ents
extolments1944404ex_tolments
fitments1376794__fit_ments
increments14410104inc_rements
recements13312284rec__ements
recrements1449354rec_rements
refinements1646794refinements
remitments1446844remit_ments
requirements2384044requirements
rescindments1752794rescindments
restatements1455284restatements
retirements1357614retirements
revilements1647134revilements
securements1545494securements
statements1256884_statements

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 Filter1786911488190.406440125.6
2DLD Change Limit148819807.72019277.1
3Display Results80800.0631269.8
 (SQL Overall)178691808.18921820.9
 
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.