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

68 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
prelusion115660(None) 
preclusion1445211preclusion
prelusions1256371prelusions
prolusion1146361prolusion
delusion937432_delusion
elusion72310952__elusion
perfusion14105882perfusion
precision13410052precision
preclusions1544662preclusions
prelusive1455582prelusive
preunion1046892pre_union
prevision1448002prevision
profusion1445702profusion
prolusions1245882prolusions
reclusion1146502_reclusion
allusion846573_allusion
collusion1146413collusion
delusions1037053_delusions
elision72311103__elision
elusions82610083__elusions
elution72913823__elution
exclusion1845223exclusion
illusion846573_illusion
inclusion11166213inclusion
occlusion1343973occlusion
pension9412203p_e_nsion
percussion1444993percussion
perfusions1595333perfusions
persuasion1294193persuasion
pervasion1446073pervasion
phelonion1444013phelonion
pleuston1044193ple_uston
plosion939113p__losion
pollution1146003pollution
preassign1244573preassign
precaution1447243precaution
precession1448823precession
precisian1347813precisian
precisions1449373precisions
preclusive1753883preclusive
predation12313463predation
prefixion2144113prefixion
prehension1546313prehension
prelection141511293prelection
preludial1244873preludial
preluding1337053preluding
prelusory1442873prelusory
prenotion1149173prenotion
preoption1348083preoption
pretension1247533pretension
preunions1146483pre_unions
previsions1547733previsions
profusions1545253profusions
propulsion1453853propulsion
protrusion1254353protrusion
prounion1046823pr_ounion
provision1447633provision
pulsion938393p_ul_sion
recision10310273_recision
reclusions1246243_reclusions
recursion1146153_recursion
relation82619773_relation
religion996743_religion
repulsion1145193_repulsion
reunion737673_re_union
revision1138713_revision
revulsion1244353_revulsion
seclusion1144943seclusion

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.406440125.6
2DLD Change Limit148641686.90321532.8
3Display Results68680.0332060.6
 (SQL Overall)178691687.34224338.2
 
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.