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

146 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
foresaw137713(None) 
forepaw1595611forepaw
forebay1538132forebay
foreman12312362foreman
forepaws1695752forepaws
foreran10311792foreran
fores85847102fores__
foresaid1247802foresaid
foresail1147822foresail
foresee10414332foresee
foreshow1785892foreshow
forest94926742fores_t
forestal11410282forestal
forestay1448192forestay
forests104114952forests
fretsaw1343922f_retsaw
resaw84117252__resaw
aforesaid1343263aforesaid
boreal84817213bore_al
boreas85421743bore_as
bores76448253bores__
coleslaw1343643coleslaw
cores76361853cores__
corsac10410173cor_sac
daresay1135433daresay
dorsa64617283dor_sa_
dorsad8408973dor_sad
dorsal74613943dor_sal
fares85852873fares__
feres86038183feres__
fireman1249333fireman
firepan1236983firepan
fires85740753fires__
foeman11311233fo_eman
foes76543443fo_es__
foetal9311883fo_etal
fora75937393for__a_
foram105124933for__am
foray115023973for__ay
forbad122710503for_bad
forbear1237523forbear
forbs105720803forbs__
forces114422133forces__
fords95328183fords__
fore78351473fore___
forearm1238703forearm
forebays1637263forebays
forebear1346383forebear
foreby1438633fore_by
forebye1536353forebye
forecast1349763forecast
foredate12310913foredate
foredid1238503foredid
foredo10510823fore_do
foreface1647113foreface
forego1038903fore_go
foregut1149163foregut
forehand1537693forehand
forehead1537893forehead
foreign1136833foreign
foreknew1843733foreknew
foreknow1842763foreknow
forelady1545073forelady
foreland1239013foreland
foreleg1137743foreleg
foremast1348613foremast
foremen12412923foremen
forename1347853forename
forensic1344943forensic
forepart1349703forepart
forepast1348043forepast
forepeak17134783forepeak
foreplay1645673foreplay
forerank1546753forerank
forerun1037653forerun
foresails1247153foresails
foreseen1139103foreseen
foreseer1139013foreseer
foresees11311643foresees
foreshadow2051823foreshadow
foreshank1944673foreshank
foreshown1864473foreshown
foreshows1875973foreshows
foreside12310303foreside
foreskin1547023foreskin
forespake18105233forespake
forespeak1843473forespeak
forestage1346973forestage
forestall1246913forestall
forestays1546623forestays
forested12312463forested
forester11313673forester
forestial1247233forestial
forestry1446723forestry
foreswear1543513foreswear
foretop12117893foretop
forever1338953forever
forewarn14117173forewarn
foreyard1546423foreyard
forgat104018583for_gat
forges105024263forges__
forks125324683forks__
formal113215213for_mal
format113021363for_mat
formes114623713formes__
forms105327053forms__
forsake1436533for_sake
fortes95327183fortes__
forts86034453forts__
fossa85812633fo_ssa_
fossae95510373fo_ssae
fossas94610703fo_ssas
fovea11310483fove_a_
foveae1237563fove_ae
foveal1237703fove_al
foveas1238623fove_as
foxes156321093foxes__
freak125115243f_re_ak
frena85915273f_rena_
fresco1136473f_resco
fresh115012203f_res_h
fretsaws1442763f_retsaws
froes86126693froes__
gores65740373gores__
loreal63814313lore_al
lores55045403lores__
mores76249643mores__
oread64619603_ore_ad
ores46056683_ores__
outsaw92610283_outsaw
oversaw13268163_oversaw
pores75849033pores__
prelaw1139103_prelaw
presa74319043_presa_
resat55139683__resat
resawn9399953__resawn
resaws93713513__resaws
resay85320543__resay
resew84519503__resew
resow88217243__resow
seesaw935973_seesaw
sores55454283sores__
sorest65028003sores_t
tores55352673tores__
warsaw1236203war_saw
yores85031323yores__

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 Filter1786911340270.810220606.2
2DLD Change Limit1340271468.28316181.0
3Display Results1461460.0463173.9
 (SQL Overall)1786911469.13919552.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.