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

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

63 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
formulae134598(None) 
formula1246291formula_
formulas1346301formulas
formulate1446991formulate
ferulae10309602fer_ulae
formulaic1652502formulaic
formulary1743842formulary
formulated1645562formulated
formulates1546542formulates
formulize23265622formulize
furculae1345072furculae
morulae958962mor_ulae
torulae758552tor_ulae
copulae112810623co_pulae
faculae123210353f_aculae
feculae12339203f_eculae
ferrule1035863ferrul_e
ferula93011173fer_ula_
ferulas103110753fer_ulas
ferule93413203fer_ul_e
fibulae12237013f_ibulae
fistulae1144533fistulae
foreplay1645673foreplay
forjudge2041853forjudge
formable1539503formable
formal113215213form__al
formalin1347313formalin
formalise14239783formalise
formalize232710033formalize
formally1638243formally
formals123312893formal_s
format113021363form__at
formate123115093form_ate
forme105225993form___e
formee113919943form__ee
formful1545183formful__
formica1436443formica_
formicas1546003formicas
formol112910333formol__
formols12299413formol_s
formularies1654163formularies
formularize2553203formularize
formulator1564583formulator
formulism16214423formulism
formulist14205913formulist
formulized25274773formulized
formulizes24255423formulizes
formyl14276443formyl__
formyls15235703formyl_s
fortunate1245453fortunate
fortune1068303fortu_ne
foveolae14104323foveolae
furcula1245803furcula_
furcular1345713furcular
morula8710473mor_ula_
morular978223mor_ular
morulas959723mor_ulas
promulge1343043promulge
reformulate1653023reformulate
torula6610393tor_ula_
torulas759853tor_ulas
yarmulke1741483yarmulke
zonulae1645963zo_nulae

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit146162637.31319986.6
3Display Results63630.0302100.0
 (SQL Overall)178691637.76623009.4
 
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.