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

55 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
denationalizing26143681denationalizing_
renationalizing25113742renationalizing_
nationalizing2355463__nationalizing_
denationalize23115904denationaliz___e
denationalized25124964denationaliz__ed
denationalizes24115524denationaliz__es
denaturalizing2563514denat_uralizing_
emotionalizing2663494_emotionalizing_
nationalising1454724__nationalising_
rationalizing2355954__rationalizing_
dematerializing28163565dematerializing_
depersonalizing2862505depersonalizing_
diagonalizing2573265d_ia_gonalizing_
fictionalizing2963265_fictionalizing_
fractionalizing30112995fractionalizing_
rationalising1454675__rationalising_
regionalizing2454615re__gionalizing_
renationalize22106385renationaliz___e
renationalized2495265renationaliz__ed
renationalizes23115905renationaliz__es
bestializing2456166be_sti__alizing_
centralizing2458056cen_t__ralizing_
deaminizing2475556de_ami_n__izing_
decarbonizing2853056decarbon__izing_
decimalizing2755966de__ci_malizing_
decriminalizing3062056decriminalizing_
deionizing2147656de___ion__izing_
delocalizing2555616de___localizing_
demoralizing2547146de___moralizing_
desacralizing2653876desa__cralizing_
desalinizing2354106desali_n__izing_
detribalizing2654016de__tribalizing_
devitalizing2645946de__vi_talizing_
devocalizing2855096de___vocalizing_
eternalizing2256246_e__ternalizing_
externalizing3054616_e_xternalizing_
fictionalising2062766_fictionalising_
gelatinizing2354056gelati_n__izing_
initializing2255286_initi__alizing_
internalizing2356216_in_ternalizing_
keratinizing2654046kerati_n__izing_
nationalities1356926__nationaliti_es
nationalize20169026__nationaliz___e
nationalized22197346__nationaliz__ed
nationalizer21176356__nationaliz__er
nationalizers22164106__nationaliz_ers
nationalizes21178616__nationaliz__es
naturalizing2255756__nat_uralizing_
personalizing2575086pe__rsonalizing_
recanalizing2446806reca___nalizing_
recapitalizing2863666recapi_talizing_
rematerializing27153526rematerializing_
sensationalize23224016sensationaliz___e
sensationalized25223516sensationaliz__ed
sensationalizes24253886sensationaliz__es

Search took 7 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 Limit65874555.68611585.3
3Display Results55550.0461195.7
 (SQL Overall)178691556.06229477.2
 
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.