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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

126 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
formed12502117(None) 
farmed125117651farmed
firmed125411881firmed
foamed126014401foamed
forced126316521forced
forded115020391forded
forged115519321forged
forked145217141forked
forme105225991forme_
formee113919941formee
former114221401former
formes114623711formes
gormed105013831gormed
normed95014541normed
wormed124314301wormed
armed86324432_armed
bermed115217722bermed
biformed1643692biformed
boomed115318132boomed
bored85034302bor_ed
borked135117292borked
corded105923352corded
cored85044222cor_ed
corked135020782corked
cormel103815602cormel
corned95224522corned
deformed15248262deformed
domed95423262do_med
doomed104113292doomed
dormer94415902dormer
famed115928342f_amed
farced125216532farced
farded114518952farded
fared95842342far_ed
farmer115017372farmer
farted105121782farted
filmed124610362filmed
fired94829742fir_ed
firmer114712442firmer
flamed124618972flamed
flumed124915262flumed
foaled104515962foaled
foamer114714312foamer
fobbed144112612fobbed
foemen11310522foemen
fogged125518372fogged
foiled104618402foiled
foined105915012foined
folded114212792folded
fonded115717042fonded
fooled104317822fooled
footed104418622footed
fopped144012672fopped
foraged124812282foraged
foramen12310532foramen
forayed14368592forayed
forbad122710502forbad
forbid123312432forbid
force105324272force_
forcer114917342forcer
forces114422132forces
ford86835492for__d
fordid113512052fordid
fore78351472for_e_
foredo10510822for_edo
foremen12412922foremen
fores85847102for_es
forfend1435412forfend
forge95126942forge_
forger104820772forger
forges105024262forges
forget106326392forget
forker134717902forker
form95836872form__
formal113215202formal
format113021352format
formers128217952formers
formic13310452formic
formol112910332formol
forms105327052form_s
formyl14276442formyl
forte86131462forte_
fortes95327182fortes
fouled104315972fouled
fowled133914102fowled
foxed165115212fo_xed
framed125116522framed
freed95223542f_reed
fremd115010322f_remd
fried95322912f_ried
fumed116118822f_umed
furled104717052furled
furred104514432furred
gored75227082gor_ed
gorged95016982gorged
harmed125218832harmed
homed115425422ho_med
horded115420482horded
horned105718702horned
horsed105321082horsed
informed14197672informed
loamed94414612loamed
loomed94616762loomed
lorded84916732lorded
orbed85516192_orbed
ormer75218372_ormer
permed115217352permed
pored85234512por_ed
porked134717622porked
ported94223242ported
reformed14249602reformed
roamed95215092roamed
roomed95218542roomed
sorbed94916522sorbed
sored66141782sor_ed
sorned74820042sorned
sorted74523712sorted
stormed1039042stormed
termed94816702termed
tommed113310142tommed
unformed14239572unformed
warmed124516892warmed
worded114316622worded
worked145314702worked
wormer114514912wormer
zoomed183610362zoomed

Search took 3 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 Filter178691825510.326548131.9
2DLD Change Limit825511262.56332208.7
3Display Results1261260.0304200.0
 (SQL Overall)1786911262.91961216.5
 
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.