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

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

35 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
fragmentarily226217(None) 
fragmentally2183022fragmenta_lly
fragmentary2072592fragmentar__y
fragmental1653643fragmenta__l_
fragmentating2062423fragmentating
fragmentation19233873fragmentation
documentarily2162644documentarily
elementarily1762724_elementarily
fragmentariness2171404fragmentariness
fragmentate1752684fragmenta__te
fragmentated1962024fragmenta_ted
fragmentates1852584fragmenta_tes
fragmentations20213564fragmentations
fragmenting1843244fragment__ing
fragmentize2652414fragment__ize
fragmentizing2982024fragmentizing
momentarily1853304__momentarily
rudimentarily1961604rudimentarily
armamentaria1672615armamentari_a
armamentarium1671765armamentarium
filamentary1952355filamentar__y
fragment1448375fragment_____
fragmented1743035fragment___ed
fragmentized2851935fragment_ized
fragmentizes2752315fragment_izes
fragments1546215fragment____s
fragrantly1752695fragrant___ly
imaginarily1751985imag_in_arily
judgmentally2661875judgmenta_lly
lamentably1743715_la_menta_bly
legendarily1651905_leg_endarily
ornamentally1763325ornamenta_lly
pigmentary1852955_pigmentar__y
segmentally1754315_segmenta_lly
segmentary1653405_segmentar__y

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 Filter1786911247900.1561145455.1
2DLD Change Limit124790358.81314159.8
3Display Results35350.0132692.3
 (SQL Overall)178691358.98219894.3
 
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.