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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 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
diffusivities236124(None) 
diffusivity2451303diffusivit__y
diffusive1952744diffusiv___e_
diffusiveness2353434diffusiveness
directivities1954194directivities
disutilities1355154di_sutilities
exclusivities2561994exclusivities
impulsivities2062014_impulsivities
affabilities2046945_affabilities
affectivities2453515affectivities
affinities1645715_aff__inities
bifidities1644455bi_f__idities
bioactivities2063305bioactivities
compulsivities2361915compulsivities
declivities1745725d__eclivities
difficulties2181655diff_iculties
diffusenesses2052825diffusenesses
diffuses1534825diffus_____es
diffusible1952355diffus__ible_
diffusionism2182095diffusi_onism
diffusionisms2281885diffusionisms
diffusionist1962655diffusi_onist
diffusionists2082265diffusionists
diffusions1743735diffus__i_ons
diffusively2452305diffusiv__ely
diffusivenesses25103865diffusivenesses
disabilities15411145di_sabilities
disinvites1445155di___sinvit_es
disquantities23101905disquantities
disunities1177785di___sunities
diversities1555875divers__ities
divinities1447735di___vinities
effectivities2453855effectivities
emissivities1752955_emissivities
erosivities1455915__erosivities
exhaustivities2791875exhaustivities
expansivities2582485expansivities
festivities1746585__festivities
fissilities1445645__fissilities
fluidities1445225__flu_idities
futilities1348865___futilities
impassivities2062955impassivities
impudicities1963235_impudicities
inactivities1755595_inactivities
infectivities2155125infectivities
infelicities1755105_infelicities
infinities1369445_inf__inities
infusibilities1955465_infusibilities
inutilities1148185_i_nutilities
liquidities2144185li_qu_idities
passivities1644905__passivities
reflexivities2662065reflexivities

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 Filter1786911247900.390458182.1
2DLD Change Limit124790527.95315690.9
3Display Results52520.0331575.8
 (SQL Overall)178691528.37621333.7
 
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.