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

129 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
fomenting153723(None) 
cementing1438762cementing
commenting1749172commenting
dementing13311042dementing
fermenting1646822fermenting
foresting13311362foresting
lamenting1237702lamenting
omening10310092_omen_ing
tormenting1345692tormenting
absenting1236993absenting
accenting1487823accenting
agenting1039383_agenting
alimenting1344503alimenting
amending12308913_amending
amounting1236643amounting
assenting1038163assenting
augmenting1443853augmenting
bonneting1236173bonneting
coempting1636073coempting
combating16310163combating
commencing1946183commencing
commending1846633commending
commuting16288443commuting
competing163712463competing
compting153013603com_pting
computing16309853computing
consenting13313223consenting
contenting13313323contenting
conventing16311543conventing
counting113115273co_unting
coveting141912303cove_ting
cozening20188303cozen_ing
denting94422183__denting
documenting1753123documenting
dominating1449403dominating
dovening13238353doven_ing
dozening19236183dozen_ing
emending12298893_emending
faceting1438783face_ting
facetting1535283facetting
fainting123312163f_ainting
feinting123410833f_einting
felting113515213f__elting
fencing132411133f__encing
fending123717603f__ending
feting104417793f__e_ting
fetting113517873f__etting
fileting1239303file_ting
flaunting1335043flaunting
fleeting122910323f_leeting
flensing1246973f_lensing
flinting123412343f_linting
foining113013453fo_in_ing
foisting122910503fo_isting
foliating1339253foliating
foment113718303foment___
fomented1437803foment_ed
fomenter1339263foment_er
fomenters1437853fomenters
foments122912053foment__s
fonding123815423fo__nding
fontina1038633fo__ntina
footing115017593fo__oting
footnoting1442563footnoting
foredating1577123foredating
foredoing1456483foredoing
foregoing1455793foregoing
forewing1539003fore_wing
forfeiting1744133forfeiting
forfending1844183forfending
forgetting1544663forgetting
formatting1644163formatting
founding133010793fo_unding
foxhunting2441833foxhunting
fragmenting1843243fragmenting
fretting122711523f_retting
friending1495553friending
fromenties1546673fromenties
fronting12310443f_ronting
garmenting1445483garmenting
henting113719653__henting
homering141512073home_ring
incenting12912063incenting
indenting11911263indenting
inventing13109973inventing
jointing16248613jo_inting
meeting103314963__meeting
melting103317753__melting
mending114018683__mending
mensing103915103__mensing
meting94320593__me_ting
minting103020813__minting
molesting1237753molesting
mounting112711813mo_unting
munting103718773__munting
nominating1349503nominating
nonending1138003nonending
nonmeeting1346073nonmeeting
offending1744093offending
omitting11217743_omitting
opening1039923_open_ing
orienting1038723orienting
parenting12611583parenting
patenting1248943patenting
pigmenting1653713pigmenting
pointing112813683po_inting
relenting102716773relenting
remeeting12311433remeeting
remelting12311703remelting
remending132311313remending
reminting122315103reminting
renting84026853__renting
repenting122316553repenting
rerenting102617663rerenting
resenting102619293resenting
romancing1446043romancing
scenting113212813_scenting
segmenting1445003segmenting
sklenting1475123sklenting
smelting11339713_smelting
something1545403something
sonneting1037003sonneting
tenting84621153__tenting
tokening1336463token_ing
venting114218093__venting
vomiting1437733vom_iting
womaning1437643woman_ing
womenkind1941513womenkind
wonting113214103wo__nting

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411296.87321626.8
3Display Results1291290.0632047.6
 (SQL Overall)1786911297.35924282.0
 
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.