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

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
formularized275247(None) 
formularize2553201formularize_
formularizer2652301formularizer
formularizes2652871formularizes
formularies1654162formulari_es
formularizers2761552formularizers
formulized25274772formul__ized
circularized26124153circularized
formalized25268933form__alized
formularizing2862173formularizing
formulated1645563formula__ted
formulize23265623formul__ize_
formulizes24255423formul__izes
modularized2452973mo_dularized
popularized2554743po_pularized
burglarized2452524bur_glarized
circularised17154274circularised
circularize24155404circularize_
circularizes25145014circularizes
communalized2853504communalized
dollarized2144704do__llarized
familiarized2752524f_amiliarized
formalised16266664form__alised
formalize232710034form__alize_
formalizer24257874form__alizer
formalizes242710074form__alizes
formicaries1853654formicari_es
formulae1345984formula___e_
formulaic1652504formula_i__c
formulary1743844formular___y
formulate1446994formula__te_
formulates1546544formula__tes
formulating1765054formulati_ng
formulation1646364formulati_on
formulations1745644formulations
normalized22358824norm__alized
polarized21610284po___larized
popularised1653784po_pularised
popularize2345684po_pularize_
popularizer2454274po_pularizer
popularizes2445524po_pularizes
regularized2244334_regularized
secularized23175724_secularized
singularized2361864singularized
solarized1969154so___larized

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 Filter1786911247900.393454684.5
2DLD Change Limit124790456.53019110.3
3Display Results45450.0301500.0
 (SQL Overall)178691456.95325699.8
 
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.