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

46 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
coercions134620(None) 
coercion1246571coercion_
coercing1349002coerci_ng
aversions1247053aversions
carrions10312453c_arrions
cercis104614493c_erci__s
cercises12410933c_ercises
cessions1039853c_essions
chorions13310663chor_ions
clarions10310493clar_ions
coactions1349743coactions
cocoons11310563co__coons
coercers1237653coerc_ers
coerces11311943coerc__es
coercible1544873coercible
coercibly1843653coercibly
coercive1545873coerci_ve
cohesions1447093cohesions
coitions10312853co_itions
colicins12312853colici_ns
conations111318903conations
conscious1347593conscious
conversions1648273conversions
cooptions13107763cooptions
cordons104415763co_r_dons
coreigns1136323co_reigns
corrasions1246353corrasions
corrections1548863corrections
corrosions1245303corrosions
cortins92421333co_rti_ns
creations112614543creations
emersions1147283emersions
eversions1238363eversions
exertions1639763exertions
fermions1336203_fermions
morions94014643mo_r_ions
morrions1077673mo_rrions
orcins83313433_o_rci_ns
pereions10310853_pereions
portions10514413po_rtions
scorpions1344213sco_rpions
ternions838813_ternions
thermions1445333thermions
torchons1337503to_rchons
torsions839183to_rsions
versions11310353_versions

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 Limit148641467.20320636.0
3Display Results46460.0133538.5
 (SQL Overall)178691467.63923391.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.