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

38 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
formularizer265230(None) 
formularize2553201formularize_
formularized2752471formularized
formularizers2761551formularizers
formularizes2652871formularizes
formularies1654162formulari_es
formalizer24257873form__alizer
formularizing2862173formularizing
formulize23265623formul__ize_
formulized25274773formul__ized
formulizes24255423formul__izes
popularizer2454273po_pularizer
circularize24155404circularize_
circularized26124154circularized
circularizes25145014circularizes
formalize232710034form__alize_
formalized25268934form__alized
formalizers25255384form__alizers
formalizes242710074form__alizes
formicaries1853654formicari_es
formulae1345984formula___e_
formulaic1652504formula_i__c
formulary1743844formular___y
formulate1446994formula__te_
formulated1645564formula__ted
formulates1546544formula__tes
formulating1765054formulati_ng
formulation1646364formulati_on
formulations1745644formulations
formulator1564584formula__tor
modularized2452974mo_dularized
normalizer21227594norm__alizer
polarizer2079174po___larizer
popularize2345684po_pularize_
popularized2554744po_pularized
popularizers2552794po_pularizers
popularizes2445524po_pularizes
secularizer22184994_secularizer

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.406440125.6
2DLD Change Limit124790386.36019621.1
3Display Results38380.0132923.1
 (SQL Overall)178691386.77926359.5
 
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.