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

49 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
fragmentariness217140(None) 
elementariness1661854_elementariness
fragmentarily2262174fragmentari__ly
fragmentates1852584fragmenta__te_s
fragmentating2062424fragmentatin__g
fragmentations20213564fragmentati_ons
fragmentizes2752314fragment__ize_s
momentariness1762934__momentariness
rudimentariness1871184rudimentariness
fragmentary2072595fragmentar____y
fragmentate1752685fragmenta__te__
fragmentated1962025fragmenta__te_d
fragmentation19233875fragmentati__on
fragmenting1843245fragment__in__g
fragmentize2652415fragment__ize__
fragmentized2851935fragment__ize_d
fragmentizing2982025fragmentizin__g
imaginariness16152005imag_in_ariness
adversariness1761836__adversariness
agentries1048236__ag_ent_ri_e_s
amantadines1453136__a_mantadine_s
argentines1146946ar_g_ent__ine_s
augmentatives1961936_augmentative_s
aventurines1453756__a_venturine_s
commentaries1856806_commentari_e_s
documentaries1863266documentari_e_s
dreariness1146286dr___e__ariness
familiarness1772056f_a_miliar_ness
fidgetiness1651916fidg_e_t__iness
fragmental1653646fragmenta_____l
fragmentally2183026fragmenta___lly
fragmented1743036fragment____e_d
fragments1546216fragment______s
franticness1643606fra___nt_icness
freakiness1745186fr___e__akiness
frequentatives29141366frequentative_s
frequentness2451826frequent___ness
friendliness1651956fr__ien_dliness
fromenties1546676fr_oment__i_e_s
frumenties1544436fr_ument__i_e_s
involuntariness1881236involuntariness
lamentableness1863586_la_mentableness
mercenariness1762586_mercen_ariness
momentarinesses1972346__momentarinesses
ordinariness1362826or__din_ariness
salutariness1253166_sa__lutariness
tramontanes1353896tra_monta__ne_s
transitoriness1482666tra_nsitoriness
voluntariness1662796__voluntariness

Search took 9 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.1061685764.2
2DLD Change Limit95024497.89312039.0
3Display Results49490.0301633.3
 (SQL Overall)178691498.02922255.7
 
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.