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

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

67 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
republication196463(None) 
prepublication2252921prepublication
republications2074451republications
prepublications2372662prepublications
publication1746572__publication
reduplication1855042reduplication
relubrication1754502relubrication
replication15712012rep__lication
publications1845833__publications
reapplication1954723reapplication
reduplications1964533reduplications
relubrications1854193relubrications
replications16811053rep__lications
republican1652323republica___n
republicanism2161333republicanism
republicanize2861483republicanize
repudiation14107603repu_di_ation
rubrication1547123r__ubrication
application1747474_ap_plication
cephalization2988184cephalization
deputization2447214depu_tization
duplication1647294__duplication
equalization3049814_equalization
explication2248454_e_xplication
implication1747774imp__lication
lubrication1546344__lubrication
nebulization2347194nebu_lization
plication13311684__p__lication
prefabrication2392824prefabrication
realization20417214re__alization
reallocation1454494re_allocation
reapplications2054254reapplications
rectification2049514rectification
rededication1646504re_dedication
reduplicating1953504reduplicating
reduplicative2172834reduplicative
regulation11312054regu_l__ation
regurgitation15143404regurgitation
rehabilitation1953274rehabilitation
reification16412904re__ification
reliction11310694re___lic_tion
relocation12312114re___location
relubricating1863094relubricating
remobilization2755694remobilization
renunciation1455314renunci_ation
repatriation14126974repatri_ation
replicating1649094rep__licating
replicative1846084rep__licative
republicanisms2271104republicanisms
republicanized3061274republicanized
republicanizes2961344republicanizes
republicanizing3181214republicanizing
republicans1752194republica__ns
repudiations1597034repu_di_ations
repunctuation1752524repunctuation
reputation12411884repu___tation
resuscitation1554294resuscitation
retaliation11612324re_tali_ation
reunification18147454reunification
reutilization2249194reutilization
revalidation1657944re_validation
ritualization2258524ritualization
rubrications1646264r__ubrications
rustication1349224r__ustication
sublimation1557184__sublimation
supplication1855394sup_plication
triplication1695384trip__lication

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.1431249587.4
2DLD Change Limit95024679.14010396.5
3Display Results67670.0461456.5
 (SQL Overall)178691679.32919154.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.