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 “foregrounding” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
foregrounding19696(None) 
foreground1572543foreground___
foregrounded186983foreground_ed
foregrounds1671823foreground__s
forerunning1552263fore_r_unning
backgrounding2471164backgrounding
foreboding1744214fore_bo__ding
forefending1943494fore__fending
foregoing1455794foreg_o___ing
grounding1236084____grounding
overfunding1945384_ove_rfunding
rebounding1435304__re_bounding
redounding1345214__re_dounding
refounding1545354__re_founding
regrinding1335704__regr_inding
regrouping1443694__regrou_ping
resounding1236364__re_sounding
surrounding1352374sur__rounding
begroaning14114115__begroan_ing
cofounding1743675co___founding
compounding1943075co__mpounding
confounding1843265co__nfounding
corresponding1962185correspo_nding
corroding1337945cor__ro__ding
expounding2142695___expounding
fireproofing2151635firepro_ofing
forboding1645145for__bo__ding
forearming1644195forear___ming
forebodings1852405fore_bo__dings
foreclosing1752965foreclo__sing
foredoing1456485fore_do___ing
foredooming1852355fore_do_oming
foregathering2151955foregathering
forejudging2451605fore__judging
foreknowing2251865forekno__wing
forelocking2142595fore_lo_cking
foreordaining1861075foreordaining
forereaching2151955fore_reaching
foreshowing2153525foresho__wing
foretokening2061325fore_tokening
forewarning1842785fore_warn_ing
forfending1844185fo___rfending
forgoing1366855for_g_o___ing
fortuning1345495fo___rtun_ing
forwarding1843495forwar___ding
founding133010795f_____ounding
freeloading1642855f_reelo_ading
freestanding1762085f_reestanding
frouncing1534765f____rouncing
groundings1343745____groundings
groundling1343395____groundling
outrebounding1751095outre_bounding
overcounting1846615_overcounting
overgoading1746565_overgo_ading
overhanding1947025_ove_rhanding
overhunting1856525_ove_rhunting
overlending1647615_ove_rlending
overrunning1545055_ove_rrunning
overwinding1955755_ove_rwinding
prefunding1745235_pre__funding
preguiding1544495_preg__uiding
propounding1744055_pr_opounding
rearousing1156465__rearou_sing
recounting1339195__re_counting
recrowning1645225__recrown_ing
refronting1437275__refro_nting
refunding14258075__re__funding
regrading121210205__regr__ading
regranting1238325__regr_anting
regreening1246035__regreen_ing
regrooming1464165__regro_oming
regrooving1553505__regro_oving
reground1045075__reground___
regrowing1436675__regro__wing
remounting1346675__re_mounting
renouncing1345105__re_nouncing
rerouting10311875__re_rou_ting
rerunning1036525__re_r_unning
responding1437405__respo_nding
retroceding1544135__retroceding
rockhounding2361015ro_ckhounding
rounding102812285_____rounding
surroundings1451265sur__roundings
typefounding227875type_founding
underfunding1873505unde_rfunding
unrounding1244875___unrounding

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit124790869.07613749.4
3Display Results86860.0501720.0
 (SQL Overall)178691869.51618778.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.