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

45 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
synchronization3272161synchronization_
synchronisation2371552synchronisation_
synchronizing3163094synchroniz__i_ng
synchronicities2572425synchroniciti_es
synchronising2262785synchroni__si_ng
synchronistic2363455synchroni_sti__c
canonization2347926___canonization_
canonizations2447246___canonizations
carbonization2675496___carbonization_
carbonizations2774956___carbonizations
colonization232010236___colonization_
colonizations24229426___colonizations
concretization2754376conc_retization_
concretizations2854036conc_retizations
decolonization26146026_decolonization_
decolonizations27145966_decolonizations
fictionization2863606_fictionization_
fictionizations2953496_fictionizations
mechanization2956326_mech_anization_
mechanizations3055816_mech_anizations
patronization2456756__patronization_
patronizations2576196__patronizations
recolonization25155886_recolonization_
recolonizations26165766_recolonizations
sclerotization25203396s_clerotization_
sclerotizations26223066s_clerotizations
securitization2554316s_ecuritization_
securitizations2654176s_ecuritizations
symbolization2954056sy__mbolization_
symbolizations3053406sy__mbolizations
synchroneities2262606synchron_eiti_es
synchronical2253526synchronica____l
synchronically2763096synchronica__lly
synchronicity2662696synchroni__ci_ty
synchronize2884186synchroniz_____e
synchronized3083576synchroniz____ed
synchronizer2983276synchroniz____er
synchronizers30102596synchroniz___ers
synchronizes2984156synchroniz____es
synchrotron19122286synchro____tron_
synchrotrons20142176synchro____trons
syncopation1853256sync__o__pation_
syncopations1952886sync__o__pations
unionization2156036_un__ionization_
unionizations2255316_un__ionizations

Search took 6 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 Filter178691658740.330541487.9
2DLD Change Limit65874455.15612776.2
3Display Results45450.0301500.0
 (SQL Overall)178691455.51632395.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.