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

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

162 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
fomented143780(None) 
fomenter1339261fomenter
cemented1338372cemented
commented16129612commented
demented12311272demented
fermented1546622fermented
foment113718302foment__
fomenters1437852fomenters
foments122912052foment_s
forested12312462forested
foveated1536292foveated
lamented1138192lamented
omened93711002_omen_ed
tormented1245962tormented
absented1156613absented
accented13107773accented
agented939423_agented
alimented1245313alimented
amended11328313_amended
amounted1135533amounted
assented957513assented
augmented1343833augmented
bonneted1136223bonneted
cementer1239193cementer
coempted1535333coempted
combated1539823combated
commenced18157133commenced
commended17137013commended
commenter151410693commenter
commuted15288983commuted
competed154113593competed
compted143813523com_pted
computed154110953computed
consented12311943consented
contented12313043contented
convented15410753convented
counted103815803co_unted
coveted133011523cove_ted
cozened19349183cozen_ed
dented84120513__dented
documented1653203documented
dominated1339883dominated
dovened12389063doven_ed
dozened18377453dozen_ed
emended11329603_emended
faceted13509563face_ted
facetted1445743facetted
fainted114211723f_ainted
feinted11379623f_einted
felted103714653f__elted
fenced124412713f__enced
fended114216913f__ended
fermenter1497543fermenter
feted94420933f__e_ted
fetted104817893f__etted
fileted1159093file_ted
flaunted1234603flaunted
fleeted113310233f_leeted
flensed1136613f_lensed
flinted114411893f_linted
floreated1346573floreated
foetid10510513fo_e_tid
foined105915013fo_in_ed
foisted113210603fo_isted
foliated1249913foliated
fomenting1537233fomenting
fomite113314073fom_ite_
fomites123613203fom_ites
fonded115717043fo__nded
footed104418623fo__oted
footnoted1342983footnoted
foredated1447683foredated
forenamed1545163forenamed
forester11313673forester
forfeited1643793forfeited
forfended1743743forfended
formatted1544883formatted
fouette1038213fouette_
fouettes1137883fouettes
founded124011423fo_unded
foveate1338363foveate_
foxhunted2341553foxhunted
fragmented1743033fragmented
fretted113411853f_retted
friended1335033friended
fromenties1546673fromenties
fromenty1645243froment_y
fronted114011273f_ronted
fumette1245523fumette_
fumettes1345773fumettes
garmented1345883garmented
hented104218753__hented
homebred16215893homebred
homered133212713home_red
homestead1544023homestead
incented112412543incented
indented101811733indented
invented122510663invented
jointed15378503jo_inted
lamenter1038863lamenter
loment84021473loment__
lomenta92710133loment_a
loments93413473loment_s
lomentum1244753lomentum
meated94222403__meated
melted94219063__melted
mended104418683__mended
mensed93916543__mensed
mentee84121293__mentee
meted85424433__me_ted
minted94220583__minted
molested11178243molested
moment103319683moment__
momenta11299853moment_a
momently1546473momently
momento11348903moment_o
momentoes13286253momentoes
momentos12338333momentos
moments113113123moment_s
momentum1144433momentum
mounted103611533mo_unted
nominated1239283nominated
offended1643653offended
omenta83411723_oment_a
omental93210413_omental
omentum1155933_omentum
omitted10347893_omitted
opened94311863_open_ed
oriented937483oriented
parented11912213parented
patented1188893patented
pigmented1544063pigmented
pointed103813983po_inted
relented92614943relented
remelted11310153remelted
remended123010393remended
reminted113615083reminted
rented74426593__rented
repented112614983repented
rerented92516163rerented
resented92716963resented
romanced1337253romanced
scented102811883_scented
segmented1345063segmented
sklented1335053sklented
smelted10399093_smelted
sonneted936183sonneted
talented938423talented
tented74221003__tented
tokened1236393token_ed
tomenta9319833toment_a
tomentum1244993tomentum
tormenter1146703tormenter
undented102313953undented
unmelted1169183unmelted
unmended12299093unmended
unrented92413923unrented
untented92613413untented
vented104617923__vented
vomited1337253vom_ited
womaned1337213woman_ed
wonted103213283wo__nted

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.410435831.7
2DLD Change Limit1461621626.54622328.4
3Display Results1621620.0602700.0
 (SQL Overall)1786911627.01625469.1
 
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.