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

71 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
scansions114532(None) 
scansion1045691scansion_
ascensions1244612ascensions
mansions1069792_mansions
scallions1145782scallions
scissions1145432scissions
sponsions1145222sponsions
suasions838782sua_sions
anions64123033__an_ions
ascension1144703ascension_
basions94213953_ba_sions
caissons1036283_caissons
camions113916133_ca_mions
campions143511293_campions
cannons94412883_can_nons
canons85522063_can__ons
cansos84915383_cans_o_s
cantons95221203_can_tons
canyons124511593_can_yons
captions123813223_captions
carrions10312453_carrions
casinos93512833_ca_sinos
cassinos10309353_cassinos
cations94524143_ca_tions
cautions103313183_cautions
cessions1039853_cessions
chansons1337473chans_ons
consigns1137533_consigns
descensions1444373descensions
eclosions1146203eclosions
erasions8310983era_sions
evasions1136543eva_sions
expansions1944153expansions
fanions103713073_fan_ions
mansion9611543_mansion_
nasions73112383_na_sions
occasions1344063occasions
passions10310583_passions
pensions10311693_pensions
recensions1248483recensions
sanctions1138873s_anctions
sanious7514103s_an_ious
sasins64923103s_a_si_ns
scabious1246593sca_bious
scalations1239783scalations
scallion1046793scallion_
scandias1137863scandi_as
scandiums1443983scandiums
scanning113310773scanni_ng
scannings12264823scannings
scanties103215423scanti_es
scanting113914763scanti_ng
scarious10610203sca_rious
scions82612243sc___ions
scission1045563scission_
scorpions1344213scorpions
scullions1154683scullions
seasons72614233sea_s_ons
secessions1246463secessions
seclusions1244633seclusions
sessions839723s_essions
sponsion1045623sponsion_
sponsons1045813spons_ons
stallions946073stallions
stanchions1543663stanchions
stations82415223sta_tions
suasion739363sua_sion_
swansdowns1751243swansdowns
swanskins1643283swanskins
tensions8310223_tensions
wanions104011373_wan_ions

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.436409841.7
2DLD Change Limit148641716.54622707.1
3Display Results71710.0302366.7
 (SQL Overall)178691717.01225483.6
 
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.