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

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

133 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
directivities195419(None) 
affectivities2453513affectivities
bioactivities2063303bioactivities
creativities1755783_creativities
declivities1745723d__eclivities
directives1655843directiv___es
directivity2054103directivit__y
effectivities2453853effectivities
erectilities1447123_erectilities
inactivities1755593_inactivities
infectivities2155123infectivities
objectivities2754313objectivities
perfectivities2483873perfectivities
reactivities1756173__reactivities
selectivities1854873selectivities
activities1548904___activities
coercivities1954244coerc_ivities
collectivities2174164collectivities
connectivities2164474connectivities
destructivities2162514destructivities
diffusivities2361254diffusivities
directive1557774directiv___e_
directorates1553014directorat_es
directories1446024direct__ories
directrices1652894direct_ri_ces
directrixes2152064direct_ri_xes
disutilities1355154di_sutilities
domesticities1863804domesticities
ductilities1446204d__uctilities
festivities1746584__festivities
overactivities2274464overactivities
perceptivities2363264perceptivities
primitivities2073564primitivities
proclivities1964684_proclivities
radioactivities21132024radioactivities
receptivities2053904receptivities
reflectivities2263624reflectivities
refractivities22103974refractivities
relativities1555774__relativities
retentivities1654554retentivities
sectilities1348694__sectilities
subjectivities2863414subjectivities
underactivities2162744underactivities
acclivities1844375__acclivities
adaptivities1853125_adaptivities
additivities1753115_additivities
aggressivities1961625aggressivities
brevities1446435_bre___vities
captivities1845945__captivities
circuities1446915cir_c__uities
conductivities2283565conductivities
deactivates1744395d_eactivat_es
debilities13411295d__e_bilities
decilitres1344995d__ec_ilitres
declivitous1751515d__eclivitous
defectives1945685defectiv___es
delectabilities2065565delectabilities
dentalities1249545d__entalities
depravities1744085d__epravities
detectabilities2065825detectabilities
detectives1645785detectiv___es
dexterities1945825d__exterities
digestibilities1963285digestibilities
digestives1545215digestiv___es
directionless1661935directionless
directions1379645direct__i_ons
directnesses1595285direct_nesses
directorate1453275directorat_e_
directorships2162975directorships
directresses15123085direct_resses
directrice1552805direct_ri_ce_
disabilities15411145di_sabilities
disentitles1255265disent__itles
diversities1555885dive__rsities
divinities1447745di___vinities
docilities1349005d__oc_ilities
drivabilities1947265drivabilities
driveabilities2055185driveabilities
durabilities1549345dur_abilities
dyeabilities1847875d_yeabilities
electricities1755235_electricities
emotivities1645755__emotivities
erosivities1455915_er_osivities
expressivities2662515expressivities
facticities1846875__facticities
fertilities1448825__fertilities
fetidities1447875__fe_tidities
gentilities1249145__gentilities
gracilities1447685_grac_ilities
hyperactivities2873775hyperactivities
identities1146955_ident__ities
imbecilities1853655imbec_ilities
inactivates1645045_inactivat_es
infertilities1656215infertilities
inutilities1148185_i_nutilities
liveabilities1846765liveabilities
motivities1547695___motivities
nativities1348435___nativities
negativities1654875_negativities
noncreativities2082765noncreativities
permittivities2162435permittivities
positivities1755455_positivities
preciosities1655375_preciosities
precipitins1746175_prec_ipitins
precocities1748165_prec_ocities
privities14312045_pr___ivities
productivities2282595productivities
reactivates1645615__reactivat_es
rectifies14310815__rect__ifies
regressivities1862535regressivities
resistivities1694505resistivities
retinites9313505__re_tinit_es
retinitides1244755__re_tinitides
retinitis948035__re_tiniti_s
retinitises1145985__re_tinitises
retractilities1674085retractilities
retroactivities2062565retroactivities
revivifies1944555__re_vivifies
rusticities1346845__rusticities
sensitivities1654535sensitivities
septicities1547315__septicities
serendipities1662635serendipities
superactivities2283775superactivities
susceptivities2162625susceptivities
tactilities1347675__tactilities
vasoactivities2272385vasoactivities
versatilities1656085versatilities
vicinities1547475vi__c_inities
virginities1544035vir__ginities
viridities14106915vir___idities
virilities1379135vir___ilities
viscidities1744475vi_sc_idities
vorticities1647095vor__ticities

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 Filter1786911247900.406440125.6
2DLD Change Limit1247901339.26313471.9
3Display Results1331330.1101209.1
 (SQL Overall)1786911339.77918272.9
 
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.