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

98 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
formula124629(None) 
formulae1345981formulae
formulas1346301formulas
ferula93011172fer_ula
formal113215202formal_
formals123312892formals
formful1545182formful_
formica1436442formica
formol112910332formol_
formols12299412formols
formulaic1652502formulaic
formulary1743842formulary
formulate1446992formulate
formyl14276442formyl_
formyls15235702formyls
furcula1245802furcula
morula8710472mor_ula
torula6610392tor_ula
coagula1045413coagula
copula102812053co_pula
cormel103815603cormel_
cormels113813373cormels
cornua85411903cornu_a
cornual94210173cornual
corolla938623corolla
doula65717773do__ula
facula112912233f_acula
famuli1136763f_amuli
fecula113310053f_ecula
fermata12278143fermata
ferrule1035863ferrule
ferulae10309603fer_ulae
ferulas103110753fer_ulas
ferule93413203fer_ule
fibula11258053f_ibula
firmly1436663firm_ly
fistula1045503fistula
foamily1546543foamily
fora75937393for___a
foramina1346163foramina
foremilk1744373foremilk
foreplay1645673foreplay
forkful1744773forkful_
forkfuls1843553forkfuls
form95836873form___
formable1539503formable
formably1846663formably
formalin1347313formalin
formally1638243formally
formant123416003formant
format113021353form_at
formate123115093formate
formats123113573formats
forme105225993form__e
formed125021173form_ed
formee113919943form_ee
former114221403form_er
formerly1645003formerly
formers128217953formers
formes114623713form_es
formic13310453form_ic
formicas1546003formicas
forming133615733forming
forms105327053form__s
formulated1645563formulated
formulates1546543formulates
formulator1564583formulator
formulism16214423formulism
formulist14205913formulist
formulize23265623formulize
fortune1068303fortune
forum108318763for_u_m
forums114611843for_ums
foul77027583fo__ul_
fouls87221433fo__uls
foveola13115013foveola
frenula1045623frenula
fumuli1135263f_umuli
furculae1345073furculae
furcular1345713furcular
gorilla836973gorilla
korma115913083korm__a
koruna1035483kor_una
morulae958963mor_ulae
morular978223mor_ular
morulas959723mor_ulas
normal83213533normal_
normals92510903normals
ormolu845833_ormolu
oscula837293_oscula
primula1145713primula
rorqual1663573rorqual
torulae758553tor_ulae
torulas759853tor_ulas
wormil1138043wormil_
wormils1236733wormils
zonula1537223zo_nula
zorilla1646023zorilla

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 Filter1786911340270.406440125.6
2DLD Change Limit134027986.42320866.7
3Display Results98980.0303266.7
 (SQL Overall)178691986.85926052.0
 
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.