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

97 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
specificities226259(None) 
specialities1656793speci_alities
specification2245763specification
specifications2345353specifications
specificity2382633specificit__y
speciosities1653763speci_osities
aperiodicities1962814aperiodicities
electricities1755234electricities
periodicities1854904_periodicities
prolificities2053474prolificities
sectilities1348694s_ec_tilities
seismicities1653374s_eismicities
septicities1547314s_e_pticities
spasticities1654624sp_asticities
specialties1544664spec__ialties
specifics1843934specific____s
specifies1647574specif____ies
specularities17123924specularities
sphericities19134204sp_hericities
bifidities1644455___bifidities
centricities1666405_centricities
civilities1547845___civilities
conicities14412645___conicities
credibilities1856075credibilities
cubicities1646825___cubicities
cyclicities1754705_cyc_licities
declivities1745725_dec_livities
edibilities1458705__edibilities
epidemicities2062295epidemicities
erectilities1447125erec_tilities
ethnicities1655445__ethnicities
facticities1846875_fac_ticities
febricities1844955_fe_bricities
felicities1549745_fe__licities
femininities1753385_femininities
flexibilities2564015flexibilities
helicities1549855_he__licities
iconicities1556665__iconicities
incivilities1756335_incivilities
legibilities1547475_legibilities
mendicities1646385_me_ndicities
miscibilities1955715miscibilities
openabilities1748625openabilities
operabilities17510055operabilities
pacification2168055_pacification
pacifications2267355_pacifications
pacificators2153005_pacificators
pacificisms2252335_pacifici_sms
pacificists2052595_pacifici_sts
peculiarities1752905_peculiarities
perspicuities1952795_perspicuities
pertinacities1754535_pertinacities
plasticities1655555_plasticities
positivities1755455_positivities
preciosities1655375preci_osities
precocities1748165prec__ocities
publicities1745485_p_ublicities
reciprocities19102305_reciprocities
scarcities1446405s__c_arcities
secularities1475515s_ecularities
securities1248555s_ec__urities
selectivities1854875selec_tivities
semiaridities1652455s_emiaridities
seminudities1552975s_eminudities
senilities10312995s_e__nilities
seniorities1148135s_eni_orities
sensibilities1557375sensibilities
sensitivities1654535sensitivities
sequacities2244765s_e_quacities
servilities1447055s_e_rvilities
sessilities1146405s_e_ssilities
sewabilities1748935s_ewabilities
silicifies1544825s___ilicifies
simplicities1864145s_implicities
sociabilities1748405s_ociabilities
socialities1349295s_oci_alities
spatialities1465565spati_alities
specialises1546005speci_ali_ses
specializes2446445speci_ali_zes
speciates13229235spec__i_at_es
specifiable2072465specifi_able_
specific1744705specific_____
specifically2453475specific_ally
specified1746255specif____ied
specifier1645685specif____ier
specifiers1743805specif__i_ers
spermicides1853315spe_rmici_des
spinosities1344955sp__inosities
spiralities1348015sp__iralities
sterilities11129015ste__rilities
supercities15411565supe___rcities
superficies1846755supe_rfic__ies
superfluities1854145supe_rfluities
superiorities1556325superi_orities
syllabicities2062915syllabicities
volcanicities2062985volcanicities
vulcanicities2062865vulcanicities

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.393454684.5
2DLD Change Limit124790978.82614138.9
3Display Results97970.0631539.7
 (SQL Overall)178691979.28219251.3
 
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.