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

55 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
explications234753(None) 
explication2248451explication_
applications1846772applications
duplications1746282duplications
expiations1959662exp_i_ations
expirations2069582exp_irations
explanations2144622explanations
explicating2356122explicati_ng
explicators2244712explicat_ors
exploitations2254212exploitations
explorations2185612explorations
extrications2149052extrications
implications1847022implications
plications14310492__plications
replications16811052replications
application1747473application_
complications2147433complications
duplication1647293duplication_
edifications1848693edifications
epilations12311713e_p_ilations
eradications1549303eradications
exaltations1847293exal_tations
examinations2167463examinations
excitations2049003ex_citations
exclamations23104103exclamations
exfoliations2244783exfoli_ations
expatiations2146133expatiations
expectations2365843expectations
expiation18710423exp_i_ation_
expiration19610713exp_iration_
explanation2045263explanation_
explantations2253643explantations
explicates2196663explicat__es
explicative2554453explicati_ve
explicator2145153explicat_o_r
explicatory2553843explicat_ory
exploitation2154703exploitation_
exploration2066713exploration_
exportations2146653exportations
expunctions2243633expunc_tions
expurgations2274123expurgations
exsiccations2343263exsiccations
extrication2049793extrication_
exultations1846523exul_tations
exuviations2195693exuvi_ations
implication1747773implication_
placations1438583__placations
plication13311683__plication_
publications1845833publications
reapplications2054253reapplications
reduplications1964533reduplications
replication15712013replication_
sexploitations2352713sexploitations
supplications1954913supplications
triplications1795073triplications

Search took 4 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 Filter178691950240.360496363.9
2DLD Change Limit95024553.32628570.1
3Display Results55550.0301833.3
 (SQL Overall)178691553.71648086.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.