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 “diffusions” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
diffusions174373(None) 
diffusion1643971diffusion_
affusions1543622_affusions
diffusing1743852diffusi_ng
diffusional1852232diffusional
diffusionism2182092diffusionism
diffusionist1962652diffusionist
diffusors1651832diffus_ors
effusions1544372_effusions
infusions1246142_infusions
suffusions1652732suffusions
affusion1443923_affusion_
confusions1546303confusions
delusions1037053d_elusions
detrusions1144213detrusions
diffusers1642773diffus_ers
diffuses1534823diffus__es
diffusible1952353diffusible
diffusionisms2281883diffusionisms
diffusionists2082263diffusionists
diffusive1952743diffusi_ve
diffusor1541903diffus_o_r
dilutions10248583di_lutions
diluvions13224443di_luvions
dimensions1344613dimensions
discussions1444243discussions
dissuasions1243523dissuasions
disunions1055973di_sunions
diversions1446533diversions
divisions1396283di_visions
divulsions1443343divulsions
effusion1444603_effusion_
fusions1039153___fusions
illusions946213_illusions
infusion1146523_infusion_
perfusions1595333perfusions
profusions1545253profusions
suffusion1552773suffusion_
allusions946014_allusions
biffins15358534biff__i_ns
collusions1245974collusions
confusion1446474confusion_
contusions1246994contusions
decisions1248384d_ecisions
decurions1246024d_ecurions
defections161510204defections
deflations1439714deflations
deflexions2142564deflexions
defusing13227934d_efusi_ng
delusion937434d_elusion_
demissions1345664demissions
derisions1038844d_erisions
detrusion1044384detrusion_
diapasons1243204diapas_ons
dictations1389704dictations
dictions111812674di__ctions
differing1746474differi_ng
diffractions2153274diffractions
diffuse1444374diffus___e
diffused1643484diffus__ed
diffusely1952024diffus_ely
diffuseness1852694diffuseness
diffuser1543144diffus__er
diffusively2452304diffusively
diffusiveness2353434diffusiveness
diffusivity2451304diffusivity
digestions1246404digestions
digressions1344744digressions
dilations102614454di_lations
dilution9239144di_lution_
diluvion12215414di_luvion_
dimension1244744dimension_
diminutions1444544diminutions
directions1379644directions
discussion1344504discussion_
disfunctions1854524disfunctions
disillusions1352324disillusions
dismissions1454004dismissions
dispassions1453884dispassions
dispersions1446454dispersions
displosions14203834displosions
disruptions14125684disruptions
dissensions12175574dissensions
dissuasion1143844dissuasion_
distensions12146274distensions
disunion956114di_sunion_
disusing1039004di_susi_ng
diurons838824di__u_rons
diversion1346454diversion_
division1266684di_vision_
divulsion1343554divulsion_
durions839964d___urions
effluxions2351734effluxions
effusing1534264_effusi_ng
elusions82610084__elusions
exclusions1945014exclusions
extrusions1745164extrusions
fissions1138034__fissions
fluxions1844424__fluxions
fusion939774___fusion_
illusion846574_illusion_
impulsions1443604_impulsions
incisions1147354_incisions
inclusions1275654inclusions
incursions1244834_incursions
infixions1943844_infixions
infusing1237894_infusi_ng
inhesions12116124_inhesions
intrusions1046334intrusions
invasions12115414_invasions
missions10311904mi__ssions
misunions1154534mi_sunions
obtrusions1263154obtrusions
occlusions1443714occlusions
perfusion14105884perfusion_
pincushions1851684pincushions
prelusions1256374prelusions
profusion1445704profusion_
prolusions1245884prolusions
reclusions1246244reclusions
seclusions1244634seclusions
suffixions2352194suffixions
suffusing1643534suffusi_ng
tiffins13327984tiff__i_ns
visions10311024vi___sions

Search took 10 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 Filter1786911614500.436409841.7
2DLD Change Limit1614501259.23317486.2
3Display Results1251250.0801562.5
 (SQL Overall)1786911259.74918329.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.