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

91 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
forefend154560(None) 
forefends1644491forefends
forfend1435411for_fend
forefeel14105512forefeel
forefeet14129392forefeet
forefelt14117362forefelt
forefended1843242forefended
forehand1537692forehand
forehead1537892forehead
foreland1239012foreland
foremen12412922foremen_
forewent1439422forewent
forfends1544832for_fends
aforehand1642813aforehand
boreen8314313bore_en_
boreens9310403bore_ens
cornfed1337383cornfe_d
defend113910493__defend
firefang1543923firefang
firemen1238773firemen_
fireweed1545353fireweed
foemen11310523fo_emen_
foraged124812283forage_d
foramen12310533foramen_
foramens1337823foramens
forayed14368593foraye_d
forced126316523for_ce_d
forded115020393for_de_d
forebear1346383forebear
foredeck1874353foredeck
foredid1238503fore_did
foredone1249733foredone
foreface1647113foreface
forefeels1593843forefeels
forefending1943493forefending
forefoot1448153forefoot
forefront1546493forefront
foregone1238583foregone
forehands1656743forehands
foreheads1647033foreheads
foreign1136833foreign_
foreknew1843733foreknew
forelands1347173forelands
foreleg1137743forele_g
forelegs1236613forelegs
foreman12312363foreman_
forepeak17134783forepeak
foreran10311793foreran_
forerank1546753forerank
forerun1037653forerun_
foreruns1146623foreruns
foresaid1247803foresaid
foresee10414333forese_e
foreseen1139103foreseen
foreseer1139013foreseer
foresees11311643foresees
forested12312463forested
foretell1146123foretell
foretold1256493foretold
forever1338953foreve_r
forevers1438173forevers
forewing1539003forewing
foreword15118963foreword
foreyard1546423foreyard
forfeit1339203for_feit
forfended1743743for_fended
forged115519323for_ge_d
forked145217143for_ke_d
formed125021173for_me_d
fornent10312933for_nent
forspent1348163forspent
fortuned1285323fortuned
forwent13310533for_went
foureyed1543663foureye_d
freed95223543f_re_e_d
friend10388933f_r_iend
moreen8313343more_en_
moreens939963more_ens
offend13365663_o_ffend
portend103411193por_tend
prebend12319443_prebend
prefund1335733_prefund
pretend104011013_pretend
refed93921923__refe_d
refeed104717623__refeed
refind104717073__refind
refund104810303__refund
relend76116453__relend
remend95216553__remend
resend75016773__resend
sorehead1246973sorehead

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.436409841.7
2DLD Change Limit146162917.37619815.9
3Display Results91910.0303033.3
 (SQL Overall)178691917.84222786.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.