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

94 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
specialisation1818275(None) 
specialisations19132421specialisations
specialization27106281specialization
specializations28115632specializations
serialization22911723s_erialization
socialization2449103s_ocialization
specialistic1854183specialis_ti_c
specification2245763speci_fication
decimalization2857884_decimalization
lexicalisation23102694_lexicalisation
penalization23512664_pe_nalization
serializations23710934s_erializations
socializations2548484s_ocializations
specialising1754014specialis__ing
specialist1448344specialis_t___
specialists1546204specialis_t__s
specialities1656794speciali__ties
speciation1449394spec___i_ation
specifications2345354speci_fications
speculation1547544spec_ul__ation
sterilization2258864steri_lization
cephalization2988185_cephalization
ciliation111112495___ci_li_ation
civilisation1753945___civilisation
conciliation1648235conci_li_ation
debilitation1547785_debi_litation
decapitation1748685_dec_apitation
decimalizations2957585_decimalizations
declination14411875_dec__lination
derealization231011535_derealization
desalination13411135_de_salination
equalization3049815__equalization
externalisation2272765externalisation
facilitation1746575_faci_litation
feudalization2657065_feudalization
focalization2649665_foc_alization
generalisation1553725generalisation
hypersalivation2662155hypersalivation
idealization22410275ide__alization
initialization2395975initialization
labialization2458345_labialization
legalization22411615_le_galization
lexicalisations2492715_lexicalisations
lexicalization32106145_lexicalization
localization23410435_loc_alization
materialization2675215materialization
mechanization2956325_mechanization
musicalization2795455musicalization
optimisation16193945op_ti_misation
pacification2168055_paci_fication
pectination15410335_pec__tination
peculation14311995_pec_ul__ation
penalizations24511635_pe_nalizations
periodization2556065_periodization
pluralization2457085_pluralization
precipitation1966225preci_pitation
radicalization26126045radicalization
realization20417225_re__alization
recalibration1754435_rec_alibration
recanalization2557675_recanalization
resocialization2664345resocialization
retaliation11612325_re_tali_ation
revalidation1657945_re_validation
revitalization2667805_revitalization
salivation1349815s____alivation
scalation11311075s__c_al__ation
secularization2565645s_ecularization
sensitisation13153645s_ensitisation
sensualization23226515sensualization
signalization2357395s_ignalization
socialistic1565815s_ocialis_ti_c
spallation1247025sp___al_lation
specialest1445575speciales_t___
specialise1446605specialis____e
specialised1654535specialis___ed
specialises1546005specialis___es
specialism1646815specialis____m
specialisms1745975specialis___ms
speciality1746335speciali__t__y
specializing2655505speciali__zing
specialties1544665special___ties
speciations1548485spec___i_ations
speculations1646395spec_ul__ations
spiculation1547035spic_ul__ation
spoliation1248425sp___oli_ation
stabilization2466195stabi_lization
sterilizations2357985steri_lizations
subtilization2456635subti_lization
thermalization2855615thermalization
trivialization2664815trivialization
verbalization2769675_verbalization
vernalization25410035_vernalization
vocalization2649995_voc_alization
vulcanisation1862425vulc_anisation

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 Filter178691950240.360496363.9
2DLD Change Limit95024946.70314176.3
3Display Results94940.0631492.1
 (SQL Overall)178691947.12625075.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.