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

105 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
foreseen113910(None) 
foresee10414331foresee_
foreseer1139011foreseer
foresees11311641foresees
forefeel14105512forefeel
forefeet14129392forefeet
foremen12412922fore_men
foreseeing1444552foreseeing
foreseers1237402foreseers
foresheet1549232foresheet
foreskin1547022foreskin
forested12312462forested
forester11313672forester
freshen133010882f_reshen
reseen64318412__reseen
unforeseen1372552unforeseen
boreen8314313bor__een
coleseed1147403coleseed
coredeem1344753coredeem
corpsmen1445623corpsmen
firemen1238773fire_men
fireweed1545353fireweed
florescent1545673florescent
foemen11310523fo_e_men
foilsmen1354103foilsmen
foramen12310533for_amen
forebear1346383forebear
forebye1536353forebye_
foredeck1874353foredeck
foredoes12310803foredoes
foredone1249733foredone
forefeels1593843forefeels
forefelt14117363forefelt
forefend1545603forefend
foregoer1237253foregoer
foregoes1239523foregoes
foregone1238583foregone
forehead1537893forehead
foreign1136833fore_ign
foreknew1843733foreknew
foreleg1137743fore_leg
forelegs1236613forelegs
foreman12312363fore_man
forenoon1146823forenoon
forepeak17134783forepeak
foreran10311793fore_ran
forerun1037653fore_run
fores85847103fores___
foresaid1247803foresaid
foresail1147823foresail
foresaw1377133fores_aw
foreshank1944673foreshank
foresheets1654603foresheets
foreshow1785893foreshow
foreshown1864473foreshown
foreside12310303foreside
foresides1339703foresides
foreskins1647043foreskins
forespeak1843473forespeak
forespoken19113773forespoken
forest94926743fores__t
forestal11410283forestal
forestay1448193forestay
foresters12312533foresters
foresting13311363foresting
forestry1446723forestry
forests104114953fores_ts
foreswear1543513foreswear
foresworn15126073foresworn
foreteeth1543563foreteeth
foretell1146123foretell
foretoken1644353foretoken
forever1338953fore_ver
forevers1438173forevers
forewarn14117173forewarn
forewent1439423forewent
forewomen1746463forewomen
foreworn14108863foreworn
forgiven1542983forgiven
formee113919943for_mee_
forsaken1543353forsaken
forspent1348163for_spent
fourteen1144503fourteen
freemen1238463f_reemen
freshed143312593f_reshed
freshens14298313f_reshens
fresher132612643f_resher
freshes133515823f_reshes
freshet133416643f_reshet
freshmen1656023f_reshmen
fresnel1035893f_resnel
frisee94217993f_risee_
frisees104411693f_risees
horsemen1347483horsemen
moreen8313343mor__een
outseen72712333_outseen
overseen112612173_overseen
preteen939873_preteen
resee54336333__resee_
reseed74823293__reseed
reseek103813133__reseek
resees63827483__resees
resewn9459813__resewn
wormseed1442963wormseed
worsen95513873wor_s_en

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621057.07620656.0
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.54523683.4
 
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.