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

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

113 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
synchronisation2371551synchronisation_
synchronization3272162synchronization_
synchronising2262784synchronis__i_ng
synchronistic2363454synchronis_ti__c
synchronicities2572425synchroniciti_es
synchronizing3163095synchroni__zi_ng
colonisation14176766___colonisation_
colonisations15216176___colonisations
synchroneities2262606synchron_eiti_es
synchronical2253526synchronica____l
synchronically2763096synchronica__lly
synchronicity2662696synchroni__ci_ty
synchronise1995026synchronis_____e
synchronised2183816synchronis____ed
synchronises2094886synchronis____es
synchronism2184576synchronis_____m
synchronisms2284256synchronis____ms
synchrotron19122286synchro____tron_
synchrotrons20142176synchro____trons
syncopation1853256sync__o__pation_
syncopations1952886sync__o__pations
unionisation1253446_un__ionisation_
unionisations1353206_un__ionisations
anachronistic2072307anachronis_ti__c
asynchronism2262797asynchronis_____m
asynchronisms2362807asynchronis____ms
canonization2347927___canonization_
canonizations2447247___canonizations
carbonization2675497___carbonization_
carbonizations2774957___carbonizations
chlorination1756247___chlorination_
chlorinations1855537___chlorinations
chrismation1853517___chr__ismation_
chrismations1953047___chr__ismations
colonization232010237___colonization_
colonizations24229427___colonizations
concretization2754377conc_retization_
concretizations2854037conc_retizations
confrontation1853227con_fron_tation_
confrontational2071597con_fron_tational
confrontations1962787con_fron_tations
coronation12412077___coron__ation_
coronations13410707___coron__ations
dechlorination2053417_dechlorination_
dechlorinations2153117_dechlorinations
decolonization26146027_decolonization_
decolonizations27145967_decolonizations
fictionization2863607_fictionization_
fictionizations2953497_fictionizations
generalisation1553727gen_eralisation_
generalisations1673627gen_eralisations
improvisation2052997__improvisation_
improvisational2261657__improvisational
improvisations2152537__improvisations
incardination1655037_incar_dination_
incardinations1754417_incar_dinations
incarnation1347467_incar_n__ation_
incarnations1446667_incar_n__ations
incoordination17172937_incoordination_
incoordinations18162657_incoordinations
incrimination17145657_inc_rimination_
incriminations18105137_inc_riminations
interanimation16136017_interanimation_
interanimations17115197_interanimations
mechanization2956327_mech_anization_
mechanizations3055817_mech_anizations
modernisation1652767_moder_nisation_
modernisations1752727_moder_nisations
patronization2456757__patronization_
patronizations2576197__patronizations
recolonization25155887_recolonization_
recolonizations26165767_recolonizations
sanctification2154707sanc_tification_
sanctifications2254137sanc_tifications
scarification2056407s__carification_
scarifications2155767s__carifications
sclerotization25203397s_clerotization_
sclerotizations26223067s_clerotizations
securitization2554317s_ecuritization_
securitizations2654177s_ecuritizations
sensitisation13153647sen__sitisation_
sensitisations1493627sen__sitisations
sonication12411187s_____onication_
sonications1349957s_____onications
specialisation18182757spec_ialisation_
specialisations19132427spec_ialisations
strobilation1454057s___trobilation_
strobilations1553887s___trobilations
symbolization2954057sy__mbolization_
symbolizations3053407sy__mbolizations
synchronal1853197synchron__a____l
synchroneity2362357synchron___ei_ty
synchronic2054657synchron____i__c
synchronies19145487synchron____i_es
synchronize2884187synchron____i_ze
synchronized3083577synchron____ized
synchronizer2983277synchron____izer
synchronizers30102597synchroni___zers
synchronizes2984157synchron____izes
synchronous1953197synchron_____ous
synchroscope2463377synchro__s__cope
syncopating1953257sync__o__pati_ng
syncretising1852397sync_retis__i_ng
syncretistic1962367sync_retis_ti__c
syndication17124967syn____dication_
syndications18104477syn____dications
unchristian1661667_unchr__is_tian_
unionization2156037_un__ionization_
unionizations2255317_un__ionizations
vulcanisation1862427vulc__anisation_
vulcanisations1962167vulc__anisations
westernisation17152577wester_nisation_
westernisations18172437wester_nisations

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.376475242.0
2DLD Change Limit950241139.36010152.1
3Display Results1131130.0931215.1
 (SQL Overall)1786911139.82918180.0
 
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.