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

95 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
decision114852(None) 
decisions1248381decisions
derision939071derision
recision10310271recision
decillion1245832decillion
decisional1344832decisional
decisioned1444142decisioned
decisive1446632decisive
decurion1146622decurion
delusion937432delusion
demission1246032demission
derisions1038842derisions
division1266682division
elision72311102_elision
excision1746272excision
incision1047602incision
indecision1344412indecision
precision13410052precision
recisions1139912recisions
revision1138712revision
benison937123benis_on
cession939813ce_ssion
concision1348493concision
decagon1135863dec_agon
deception1448323deception
deciding132210833deciding
decillions1345433decillions
decimation15411623decimation
decisioning1543933decisioning
declension1343513declension
decoction1447523decoction
decurions1246023decurions
delation92318083delation
deletion92011973deletion
delusions1037053delusions
demising122012523demising
demissions1345663demissions
demotion1169073demotion
dentition1049633dentition
depiction1437273depiction
derisive1247503derisive
descension1344543descension
design8408933de__sign
detrition1049133detrition
detrusion1044383detrusion
deviation13312393deviation
devising133111523devising
devisor11357043devis_or
devotion1256763devotion
diction102313053dic_tion
divisions1396283divisions
dominion11147033dominion
eclosion1046893_eclosion
edition8310853_edition
elisions82210423_elisions
elusion72310953_elusion
emission1047673_emission
envision1145953envision
erasion7311963_erasion
erosion7311113_erosion
evasion1036753_evasion
excisions1846383excisions
incisions1147353incisions
indecisions1444113indecisions
lection92614863lec_tion
lenition8310083lenition
lesion64715063le__sion
lewisson1142023lewisson
nondecision1453843nondecision
occasion1244213occasion
pension9412203pe_nsion
petition10711753petition
precisian1347813precisian
precisions1449373precisions
prevision1448003prevision
recension1148863recension
recession1149103recession
reclusion1146503reclusion
recursion1146153recursion
religion996743religion
remission1147333remission
rescission1244863rescission
revisions1238593revisions
scission1045563_scission
secession1146703secession
seclusion1144943seclusion
section92515663sec_tion
sedition939333sedition
seisin63715123se_isi_n
session739763se_ssion
subdecision1652883subdecision
tension7311803te_nsion
venison1036443venis_on
version10310923ve_rsion
vision9311313__vision

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 Filter1786911461620.470380193.6
2DLD Change Limit146162958.15617920.8
3Display Results95950.0303166.7
 (SQL Overall)178691958.65620643.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.