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

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

68 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
foreseeable165274(None) 
unforeseeable1861522unforeseeable
forceable1646213for__ceable
forgeable1545403for__geable
freezable2345093f_re_ezable
agreeable1244654agr__eeable
feedable1437674f__e_edable
fireable131710224fir___eable
focusable1644094focus__able
fordable1439594for___dable
forecastable1982094forecastable
forefeel14105514forefee__l_
forefeels1593844forefee__ls
foresail1147824fores__ail_
foresails1247154fores__ails
foresee10414334fores_e___e
foreseeability2262384foreseeability
foreseeing1444554foresee_ing
foreseen1139104foresee___n
foreseer1139014foresee___r
foreseers1237404foresee__rs
foresees11311644foresee___s
forespake18105234fores_pa_ke
forespeak1843474forespea__k
forespeaks1943124forespea_ks
forestage1346974fores_ta_ge
forestal11410284fores_ta_l_
forestall1246914fores_ta_ll
forestalled1553384fores_talled
forestaller1453254fores_taller
forestalls1345804fores_talls
forestial1247234forestia_l_
foreswear1543514foreswea__r
foreswears1643224foreswea_rs
forfeitable1962784forfeitable
forgettable1752104forgettable
forgivable1942744for_givable
formable1539504for___mable
formidable1843484for_midable
frameable1645354f_r_ameable
irredeemable17152374irredeemable
irremeable1444704irre_meable
nonrenewable1782624nonrenewable
orderable1246184_or_derable
preferable1746724_preferable
presentable1546034_presentable
preservable1844164_preservable
presumable1645194_presumable
redeemable1543954__redeemable
reefable1339534__re_efable
reelable10311594__re_elable
referable1439624__referable
relegable1258104__relegable
renewable1447434__renewable
resalable1138734__resalable
rescuable1347584__rescuable
resealable1246184__resealable
resectable1478124__resectable
resemble1247304__res_emble
reservable1546364__reservable
resettable1256504__resettable
restable101618434__res_table
resumable1347554__resumable
reverable14310364__reverable
screenable1443704scre_enable
seeable91113944____seeable
unredeemable1752574unredeemable
unseeable1149454__unseeable

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 Filter1786911488190.1731032896.0
2DLD Change Limit148819689.53315610.9
3Display Results68680.0461478.3
 (SQL Overall)178691689.75218323.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.