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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
intercede12121098(None) 
interceded14138201interceded
interceder13198441interceder
intercedes131610431intercedes
antecede1145032ante_cede
interbed112413102interbed_
interbeds12238902interbeds
interceders14136432interceders
intercell1148162intercell
intercept13410962intercept
interfere12410812interfere
interlude1047292interlude
interned93016652interned_
internee82718512interne_e
internode1048762internode
interred92615262interred_
intervene12912242intervene
anteceded1343473ante_ceded
antecedes1245063ante_cedes
entered82718883enter_ed_
inferred12248353inferred_
inhered11313163inher_ed_
innerved1246293innerved_
inserted92413053inserted_
intended102310413intended_
intendeds11265743intendeds
interacted13411213interacted_
interage9314483inter_age
interbedded1643763interbedded
interbred1248743interbred_
interbreed1346873interbreed
intercaste1249273intercaste
interceding1568043interceding
intercepted16157723intercepted
intercepter15127913intercepter
intercepts1448633intercepts
intercity14410003intercity
interclan1148603interclan
interclub1344393interclub
intercom1248683interc_om
intercoms1349333intercoms
intercrop1345763intercrop
intercut10411113interc_ut
intercuts1148783intercuts
interest8319183inter_est
interface14410163interface
interfaced1647933interfaced_
interfered1448533interfered
interferer1347733interferer
interferes1349983interferes
interfile12411043interfile
interfuse1247433interfuse
intergrade1247363intergrade
interject1849603interject
interlace11311903interlace
interlaced1349223interlaced_
interleaf1248043interleaf
interleave1347613interleave
interlend10310113interlend
interlends1148603interlends
interlent9416733interlent
interline91218003interline
interlope1149183interlope
interludes1147393interludes
intermale11712293intermale
intermeddle1553243intermeddle
intermedin1347443intermedin
interment11419223interment
intermesh1446703intermesh
interne73218143inter__ne
internees93014843internees
internes82721233interne_s
internodes1148673internodes
interocean1246483interocean
interpled1239603interpled_
interpose11410463interpose
interrace11312543interrace
interreges1148843interreges
interrex15249823interre_x
intersect11412113intersect
intersex15209733interse_x
intersexes1747913intersexes
interterm1148813interterm
intertie8317613inter_tie
intervale12911583intervale
intervened14109053intervened
intervener13109013intervener
intervenes131012643intervenes
interweave1646253interweave
interwove1547143interwove
interzone1849353interzone
intorted9310123intorted_
intrude837403int_r_ude
inturned9268313inturned_
inversed12269283inversed_
inverted122312163inverted_
sintered92213903sinter_ed_
supercede1478483supercede
wintered122111573winter_ed_
winterfed1644993winterfed_
winterfeed1743963winterfeed
wintertide1444453wintertide

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411027.39020113.8
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.85922737.1
 
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.