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

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

72 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
synchronisation237155(None) 
synchronization3272161synchronization
synchronistic2363453synchronis_ti_c
synchronicities2572424synchronicities
synchronising2262784synchronis__ing
colonisation14176765___colonisation
synchroneities2262605synchron_eities
synchronical2253525synchronica___l
synchronically2763095synchronica_lly
synchronicity2662695synchroni__city
synchronise1995025synchronis____e
synchronised2183815synchronis___ed
synchronises2094885synchronis___es
synchronism2184575synchronis____m
synchronisms2284255synchronis___ms
synchronizing3163095synchroni__zing
synchrotron19122285synchro____tron
syncopation1853255sync__o__pation
unionisation1253445_un__ionisation
anachronistic2072306anachronis_ti_c
asynchronism2262796asynchronis____m
asynchronisms2362806asynchronis___ms
canonization2347926___canonization
carbonization2675496___carbonization
chlorination1756246___chlorination
chrismation1853516___chr__ismation
colonisations15216176___colonisations
colonization232010236___colonization
concretization2754376conc_retization
confrontation1853226con_fron_tation
coronation12412076___coron__ation
dechlorination2053416_dechlorination
decolonization26146026_decolonization
fictionization2863606_fictionization
generalisation1553726gen_eralisation
improvisation2052996__improvisation
incardination1655036_incar_dination
incarnation1347466_incar_n__ation
incoordination17172936_incoordination
incrimination17145656_inc_rimination
interanimation16136016_interanimation
mechanization2956326_mech_anization
modernisation1652766_moder_nisation
patronization2456756__patronization
recolonization25155886_recolonization
sanctification2154706sanc_tification
scarification2056406s__carification
sclerotization25203396s_clerotization
securitization2554316s_ecuritization
sensitisation13153646sen__sitisation
sonication12411186s_____onication
specialisation18182756spec_ialisation
strobilation1454056s___trobilation
symbolization2954056sy__mbolization
synchronal1853196synchron__a___l
synchroneity2362356synchron___eity
synchronic2054656synchron____i_c
synchronies19145486synchron____ies
synchronize2884186synchron____ize
synchronized3083576synchroni___zed
synchronizer2983276synchroni___zer
synchronizers30102596synchroni__zers
synchronizes2984156synchroni___zes
synchrotrons20142176synchro____trons
syncopations1952886sync__o__pations
syncretistic1962366sync_retis_ti_c
syndication17124966syn____dication
unchristian1661666_unchr__is_tian
unionisations1353206_un__ionisations
unionization2156036_un__ionization
vulcanisation1862426vulc__anisation
westernisation17152576wester_nisation

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 Filter178691950240.360496363.9
2DLD Change Limit95024729.21610310.8
3Display Results72720.0461565.2
 (SQL Overall)178691729.62218571.1
 
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.