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

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

73 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
forebears144641(None) 
forbears1337071for_bears
forebear1346381forebear_
forbear1237522for_bear_
forebays1637262foreb_ays
foreheads1647032foreheads
forepeaks18104572forepeaks
foreseers1237402foreseers
foreswears1643222foreswears
forevers1438172foreve_rs
forswears1543242forswears
fireboard1546613fireboard
fireboards1645433fireboards
fireboats1446413fireboats
firebrats1445883firebrats
firebreaks1972883firebreaks
footgears13103073footgears
foragers12349633forage_rs
forayers14277273foraye_rs
forbare122310513for_b_are
forbearer1444513for_bearer
forbearers1543673for_bearers
forcemeats1742813forcemeats
forcers124215713for_ce_rs
forearm1238693for__earm
forearms1336603for__earms
forebay1538133foreb_a_y
foreboders1644173foreboders
forebodes1547613forebodes
forebooms1645333forebooms
forebrain1445163forebrain
forebrains1544623forebrains
foredecks1973383foredecks
forefeels1593843forefeels
forefends1644493forefends
foregoers1345953foregoers
forehead1537893forehea_d
forelegs1236613forele_gs
forepart1349703fore_part
foreparts1445223fore_parts
forepaws1695753fore_paws
forepeak17134783forepea_k
foreplays1745043foreplays
forereach1743663forereach
foreseer1139013foreseer_
foresees11311643forese_es
forespeaks1943123forespeaks
forestays1546623forestays
foresters12312533foresters
foreswear1543513foreswear_
foretells1245633foretells
forever1338953foreve_r_
forewarn14117163fore_warn
forewarns1585633fore_warns
foreyard1546423fore_yard
foreyards1645503fore_yards
forgers115218183for_ge_rs
forgoers1236413forgoe_rs
forkers144615783for_ke_rs
formers128217953for_me_rs
forswear1443293forswear_
freers94717303f_re_e_rs
hornbeams1642293hornbeams
horsebeans1583623horsebeans
overbears14208483_overbears
rebars84019833__reb_ars
redears82814453__redears
regears83012463__regears
rehears103312773__rehears
retears72814923__retears
rewears102911033__rewears
soreheads1346073soreheads
wormgears1541923wormgears

Search took 7 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.1731032896.0
2DLD Change Limit148641736.62322443.2
3Display Results73730.0332212.1
 (SQL Overall)178691736.82926166.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.