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 “derisions” 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
derisions103884(None) 
decisions1248381decisions
derision939071derision_
decision1148522decision_
delusions1037052delusions
demissions1345662demissions
detritions1148952detritions
detrusions1144212detrusions
divisions1396282divisions
elisions82210422_elisions
erasions8310982_erasions
erosions8310342_erosions
recisions1139912recisions
revisions1238592revisions
versions11310352ver_sions
abrasions1145813abrasions
aerations9317903aerations
aversions1247053aver_sions
benisons1037043benis_ons
cessions1039853ce_ssions
chrismons1644003chrismons
decillions1345433decillions
decisional1344833decisional
decisioned1444143decisioned
decurions1246023decurions
definiens1345303definiens
delations102616593delations
deletions102610933deletions
delicious1246713delicious
delirious1045603delirious
delusion937433delusion_
demising122012523demisi_ng
demission1246033demission_
demotions1258443demotions
dentitions1148853dentitions
depictions1546893depictions
depressions1447313depressions
deraigns1034883der_aigns
deriding112512933deridi_ng
derisible1245773derisible
derisive1247503derisi_ve
derisory1245163deris_ory
derivations15611493derivations
deriving132510743derivi_ng
designs9328313de__signs
detrition1049133detrition_
detrusion1044383detrusion_
deviations14311163deviations
devising133111523devisi_ng
devisors12347253devis_ors
devotions1356593devotions
diversions1446533diver_sions
division1266683division_
dominions12126553dominions
durations10311463durations
durions839963dur__ions
editions9310403_editions
elision72311103_elision_
elusions82610083_elusions
emersions1147283emer_sions
emissions1146923_emissions
envisions1245613envisions
erasion7311963_erasion_
erosion7311113_erosion_
evasions1136543_evasions
eversions1238363ever_sions
excisions1846383excisions
fermions1336203fer_mions
frissons1145043_frissons
grisons838993_gris_ons
incisions1147353incisions
indecisions1444113indecisions
lenitions939473lenitions
lesions73813873le__sions
lewissons1241743lewissons
meridians1245543meridians
merisis93213173merisi__s
orisons7310563_oris_ons
pensions10311693pe_nsions
perditions1348873perditions
pereions10310853per_eions
perfusions1595333perfusions
perigons11310083peri_gons
permissions1545333permissions
persons93717013per_s_ons
pervasions1545663pervasions
petitions11511083petitions
precisions1449373precisions
previsions1547733previsions
prisons9313223_pris_ons
recision10310273recision_
religions1086603religions
remissions1246613remissions
rerising93017783rerisi_ng
revision1138713revision_
seditions1039013seditions
seisins73614393se_isi_ns
seriations10316683seriations
sericins10312463serici_ns
sessions839723se_ssions
tensions8310223te_nsions
ternions838813ter_nions
torsions839183tor_sions
venisons1136133venis_ons
verismos13284693verismo_s
vermilions1543873vermilions
version10310923ver_sion_
visions10311023__visions
warisons1136903waris_ons

Search took 7 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 Limit1486411096.43623095.2
3Display Results1091090.0462369.6
 (SQL Overall)1786911096.90525878.5
 
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.