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 “forewent” 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
forewent143942(None) 
forwent13310531for_went
forefeet14129392forefeet
forefelt14117362forefelt
forefend1545602forefend
foremen12412922foremen_
forewing1539002forewing
fornent10312932for_nent
forspent1348162forspent
bodement13410123bodement
boreen8314313bore_en_
boreens9310403bore_ens
cerement12315133cerement
coherent13412473coherent
copresent1349923copresent
credent10313973_credent
dormient1148453dormient
farewell1443313farewell
ferment12315573fer_ment
fervent13310063fer_vent
fewest12311663f__ewest
firemen1238773firemen_
fireweed1545353fireweed
florescent1545673florescent
foemen11310523fo_emen_
foment113718303fo__ment
foramen12310533foramen_
foramens1337823foramens
forcemeat1644253forcemeat
forebear1346383forebear
forecast1349763forecast
foredeck1874353foredeck
foredone1249733foredone
forefeel14105513forefeel
forefends1644493forefends
forefoot1448153forefoot
forefront1546493forefront
foregone1238583foregone
foregut1149163fore_gut
forehand1537693forehand
forehead1537893forehead
foreign1136833foreign_
foreknew1843733foreknew
foreland1239013foreland
foreleg1137743forele_g
forelegs1236613forelegs
foreman12312363foreman_
foremast1348613foremast
foremost1348583foremost
forepart1349703forepart
forepast1348043forepast
forepeak17134783forepeak
foreran10311793foreran_
forerank1546753forerank
forerun1037653forerun_
foreruns1146623foreruns
foresee10414333forese_e
foreseen1139103foreseen
foreseer1139013foreseer
foresees11311643foresees
foresheet1549233foresheet
forest94926743for__est
foreswear1543513foreswear
foreteeth1543563foreteeth
foretell1146123foretell
forever1338953foreve_r
forevers1438173forevers
forewarn14117173forewarn
forewarns1585633forewarns
forewings1645113forewings
forewomen1746463forewomen_
foreword15118963foreword
foreworn14108863foreworn
forfeit1339203for_feit
forfend1435413for_fend
forget106326393for_ge_t
forint9325023for__int
forkiest153812303forkiest
formant123416003for_mant
forswear1443293forswear
freest95318283f_re_est
frequent2046423f_requent
horrent10313553hor_rent
mordent10313993mor_dent
moreen8313343more_en_
moreens939963more_ens
movement1549433movement
nonevent11410163nonevent
orient6322533_or_ient
outwent10311363_outwent
portent93619643por_tent
precent113520263_precent
present94022733_present
prevent124016553_prevent
recent83630853__recent
regent74127673__regent
relent64431853__relent
repent84728873__repent
rerent63832453__rerent
resent63833623__resent
rewet85135153__rewe_t
sorbent92915243sor_bent
strewment1445683strewment
torment9316173tor_ment
torrent7313413tor_rent

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 Limit1461621056.78021557.8
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.24924650.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.