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

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
foaming13361299(None) 
coaming123818321coaming
faming124922971f_aming
flaming134216441flaming
foaling113515841foaling
forming133615731forming
framing133014791framing
loaming103613731loaming
roaming103215791roaming
beaming123618802beaming
blaming123515692blaming
boating103721302boating
booming123716222booming
coaling103722822coaling
coamings13349292coamings
coating103525312coating
coaxing173511702coaxing
coming114225452co_ming
defoaming1645652defoaming
doating93816862doating
doming104218392do_ming
dooming113112532dooming
facing125321572f_acing
fading114821112f_ading
faking145520982f_aking
famine114318192f_amine
faring105231282f_aring
farming133515082farming
fating105328672f_ating
faxing175117052f_axing
faying134521072f_aying
fazing194418642f_azing
fearing113520032fearing
feasing113916652feasing
feazing205411442feazing
filming133210352filming
firming132811222firming
flaking154114492flaking
flamingo14274142flamingo
flamming16357152flamming
flaring114116802flaring
flawing143812562flawing
flaying143914462flaying
floating123111882floating
fluming133512792fluming
foamier12339002foamier
foamily1546542foamily
fobbing153410272fobbing
fogging133513732fogging
foiling113317652foiling
foining113013452foining
folding123912442folding
fonding123815422fonding
fooling113117372fooling
footing115017592footing
fopping153511132fopping
foraging1358062foraging
foramina1346162foramina
foraying1537432foraying
forcing134013752forcing
fording123717042fording
forging124114722forging
forking154014842forking
fouling113315372fouling
fowling143713112fowling
foxing175012432fo_xing
framings14338132framings
fraying143413432fraying
fuming124013292f_uming
gaming104622042_gaming
gloaming12268012gloaming
goading103112852goading
goaling93515332goaling
gorming112810832gorming
hoaxing18307762hoaxing
homing123718382ho_ming
laming94528362_laming
loading94114612loading
loafing11319792loafing
loaning83614832loaning
looming102814852looming
moaning103714442moaning
moating104218152moating
naming93917892_naming
oaring74225302_oaring
reaming103924012reaming
roaring82916002roaring
rooming104117042rooming
seaming103222112seaming
shaming133016742shaming
soaking123116612soaking
soaping103616222soaping
soaring83521892soaring
taming94023432_taming
teaming103917592teaming
tomming12359242tomming
worming132811242worming
zooming19269652zooming

Search took 4 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 Filter1786911076710.360496363.9
2DLD Change Limit107671983.20333615.7
3Display Results98980.0462130.4
 (SQL Overall)178691983.60949512.6
 
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.