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

87 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
forecast134976(None) 
forecasts1445801forecasts
foremast1348611foremast
forepast1348041forepast
forecasted1685102forecasted
forecaster1586002forecaster
forecastle1552612forecastle
foremasts1445792foremasts
foremost1348582foremost
forepart1349702forepart
forest94926742fore__st
foretaste1295862foretaste
precast11314852_precast
recast83422772__recast
abreast9311273abre_ast
arecas84817443_arecas_
boreas85421733bore_as_
breast8319633_bre_ast
cosecant12410683cosecant
downcast1445003downcast
feast85932723f__e_ast
fiercest13216143fiercest
firebase1346493firebase
forceps14466983forceps_
forcers124215713forcers_
forces114422133for_ces_
forearm1238693fore_arm
forebay1538133foreba_y
forebays1637263forebays
forecasters1675003forecasters
forecasting1744473forecasting
forecastles1652183forecastles
foreclose1444623foreclose
forecourt1445753forecourt
foredate12310913foredate
foreface1647113foreface
forefeet14129393forefeet
forefelt14117363forefelt
forefoot1448153forefoot
foregut1149163fore_gut
foreguts1245563foreguts
forehand1537693forehand
forelady1545073forelady
foreland1239013foreland
foreman12312363forema_n
forename1347853forename
foreparts1445223foreparts
forepaw1595613forepa_w
forepaws1695753forepaws
foreran10311793forera_n
forerank1546753forerank
fores85847103fore__s_
foresaid1247803foresaid
foresail1147823foresail
foresaw1377133foresa_w
forests104114953fore__sts
foretasted1484753foretasted
foretastes1375593foretastes
forewarn14117163forewarn
forewent1439423forewent
foreyard1546423foreyard
forgat104018583for_ga_t
forkiest153812303forkiest
formant123416003for_mant
format113021353for_ma_t
formats123113573for_mats
formicas1546003formicas_
foveas1238623fove_as_
fracas11311993f_racas_
freest95318283f_re_est
notecase1044823notecase
offcast1544473_offcast
opencast1244863_opencast
orcas75918623_or_cas_
orgiast837463_orgiast
outcast91013743_outcast
overcast132411973_overcast
polecat11313143poleca_t
polecats1248833polecats
precasts1239453_precasts
recant83228683__recant
recasts93413533__recasts
repast83520633__repast
solecist10910783solecist
sorest65028003sore__st
telecast1048293telecast
typecast1545273typecast

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162876.45322650.2
3Display Results87870.0302900.0
 (SQL Overall)178691876.63926915.3
 
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.