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

109 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
derision93907(None) 
decision1148521decision
derisions1038841derisions
decisions1248382decisions
delusion937432delusion
demission1246032demission
derisive1247502derisive
detrition1049132detrition
detrusion1044382detrusion
division1266682division
elision72311102_elision
erasion7311962_erasion
erosion7311122_erosion
recision10310272recision
revision1138722revision
version10310922ver_sion
abrasion1046633abrasion
aeration8319933aeration
aversion1147313aver_sion
benison937123benis_on
cession939813ce_ssion
chrismon1544643chrismon
decillion1245833decillion
decisional1344833decisional
decisioned1444143decisioned
decisive1446633decisive
decurion1146623decurion
delation92318083delation
deletion92011973deletion
delusions1037053delusions
demising122012523demising
demissions1345663demissions
demotion1169073demotion
dentition1049633dentition
depiction1437273depiction
depression1347503depression
deraign936573der_aign
deriding112512933deriding
derisible1245773derisible
derisory1245163derisory
derivation14712783derivation
deriving132510743deriving
design8408933de__sign
detritions1148953detritions
detrusions1144213detrusions
deviation13312403deviation
devising133111523devising
devisor11357043devis_or
devotion1256763devotion
diversion1346453diver_sion
divisions1396283divisions
dominion11147033dominion
duration9312693duration
durion7510963dur__ion
edition8310853_edition
elisions82210423_elisions
elusion72310953_elusion
emersion1047733emer_sion
emission1047673_emission
envision1145953envision
erasions8310983_erasions
erosions8310343_erosions
evasion1036753_evasion
eversion1138713ever_sion
excision1746273excision
fermion1236763fer_mion
frisson1045313_frisson
grison7310103_gris_on
incision1047603incision
indecision1344413indecision
lenition8310083lenition
lesion64715063le__sion
lewisson1142023lewisson
meridian1147683meridian
merisis93213173merisi_s
orison6411663_oris_on
pension9412203pe_nsion
perdition1249013perdition
pereion9312053per_eion
perfusion14105883perfusion
perigon1039853peri_gon
permission1445713permission
person83517873per_s_on
pervasion1446073pervasion
petition10711753petition
precision13410053precision
prevision1448013prevision
prison8514023_pris_on
recisions1139913recisions
religion996743religion
remission1147333remission
rerisen73613643reris_en
rerising93017783rerising
revisions1238603revisions
sedition939333sedition
seisin63715123se_isi_n
seriation9318063seriation
sericin9312843serici_n
session739763se_ssion
tension7311803te_nsion
ternion739493ter_nion
torsion7310803tor_sion
venison1036453venis_on
verismo12276393verismo_
verismos13284693verismos
vermilion1444333vermilion
versions11310353ver_sions
vision9311313__vision
warison1037083waris_on

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 Filter1786911461620.546327272.9
2DLD Change Limit1461621097.37319824.0
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.96522434.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.