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

293 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
forewing153900(None) 
forewings1645111forewings
brewing133411152_brewing
crewing133212622_crewing
foraging1358062foraging
foraying1537432foraying
forcing134013752for_cing
fording123717042for_ding
fordoing1357302fordoing
foredoing1456482foredoing
foregoing1455792foregoing
foreign1136832fore_ign
foresting13311362foresting
forewent1439422forewent
forging124114722for_ging
forgoing1366852forgoing
forking154014842for_king
forming133615732for_ming
freeing113713912f_reeing
screwing14288222screwing
shrewing15228082shrewing
strewing12289842strewing
agreeing10295903agreeing
arrowing1237943arrowing
bedewing1537143bedewing
bitewing1435293bitewing
bogeying1575703bogeying
borating113414503borating
bordering1338833bordering
boring94724873bor__ing
borking144716173bor_king
borrowing1544563borrowing
boweling143410683boweling
bowering142911713bowering
bowing124723063bo__wing
brewings14296693_brewings
chewing163911143_chewing
clewing13359583_clewing
coercing1349003coercing
cohering142413833cohering
cooeeing1137453cooeeing
cooeying1438143cooeying
corbeling1439033corbeling
cording113620823cor_ding
coreign1037343core_ign
coring94433963cor__ing
corking143018823cor_king
cornering12311893cornering
corning103720123cor_ning
corseting12312173corseting
covering142215723covering
coveting141912303coveting
cowering142514033cowering
cowing124526323co__wing
cozening20188303cozening
creping122913653_creping
crowing133814763_crowing
dewing114115703__dewing
dovening13238353dovening
doweling13279763doweling
dowering132510613dowering
dowing114221513do__wing
dozening19236183dozening
drawing123812053_drawing
dreeing94311183_dreeing
faceting1438783faceting
farcing133514003far_cing
farding123716743far_ding
faring105231283far__ing
farming133515083far_ming
farrowing1645873farrowing
farseeing1344383farseeing
farthing1538073farthing
farting114120753far_ting
fedexing2034493fedexing
feeding123515073f_eeding
feeing104416503f__eeing
feeling113617073f_eeling
feezing204610163f_eezing
ferreling13136273ferreling
ferreting13127693ferreting
ferrying15146243ferrying
feruling1258873feruling
feting104417793f__eting
feuing104412273f__euing
fevering152510083fevering
fileting1239303fileting
firefang1543923firefang
firepink1753983firepink
firing104021723fir__ing
firming132811223fir_ming
flawing143812563f_lawing
fleecing14347573fleecing
fleeing113511293f_leeing
fleering123811283fleering
fleeting122910323fleeting
flexing18358993f_lexing
fleying14329873f_leying
flowering1636053flowering
flowing143411763f_lowing
foaling113515843fo_aling
foaming133612993fo_aming
fobbing153410273fo_bbing
focusing1436603focusing
foddering1535163foddering
fogging133513733fo_gging
foiling113317653fo_iling
foining113013453fo_ining
foisting122910503foisting
folding123912443fo_lding
folioing1237573folioing
following1665753following
fomenting1537233fomenting
fonding123815423fo_nding
fondling13189353fondling
fonduing13245893fonduing
fooling113117373fo_oling
footing115017593fo_oting
footling12239923footling
foozling21275723foozling
fopping153511133fo_pping
foramina1346163foramina
forbearing1644803forbearing
forboding1645143forboding
forearming1644193forearming
foreboding1744213foreboding
foredating1577123foredating
foredid1238503foredi_d
foredone1249733foredone
forefend1545603forefend
forefinger17103333forefinger
foregone1238583foregone
forehand1537693forehand
foreknowing2251863foreknowing
foreland1239013foreland
foreleg1137743fore_leg
forelimb1544083forelimb
foreman12312363foreman_
foremen12412923foremen_
foremilk1744373foremilk
foreran10311793foreran_
forerank1546753forerank
forerun1037653forerun_
foreruns1146623foreruns
foreseeing1444553foreseeing
foreshowing2153523foreshowing
foreside12310303foreside
foreskin1547023foreskin_
foreskins1647043foreskins
foretime1348213foretime
forewarn14117163forewarn
forewarning1842783forewarning
forewarns1585633forewarns
foreword15118953foreword
foreworn14108853foreworn
forfeiting1744133forfeiting
forfending1844183forfending
forgetting1544663forgetting
forgings13287703for_gings
forgiving1744343forgiving
forint9325023for__int
forsaking1745173forsaking
fortuning1345493fortuning
forwent13310533for_went
fostering132411263fostering
fouling113315373fo_uling
founding133010793founding
fowling143713113fo_wling
foxing175012433fo__xing
framing133014793f_raming
fraying143413433f_raying
freaking163611453f_reaking
freezing21308323freezing
freshing152611023f_reshing
fretting122711523f_retting
frizing203310873f_rizing
frocking18309573frocking
frogging14358733frogging
fronting12310443fronting
frosting12311183frosting
frothing15208533frothing
frowning15307833frowning
frying134511403f_r_ying
fueling113615133f_ueling
furling114016563fur_ling
furring114013143fur_ring
furrowing1644063furrowing
gorging102611363gor_ging
goring84119573gor__ing
gorming112810833gor_ming
greeing93613783_greeing
greying124110893_greying
growing123512473_growing
hewing134514243__hewing
hireling121210993hireling
hoeing104117023ho_e_ing
homering141512073homering
honeying1537673honeying
hording123517053hor_ding
horning113015003hor_ning
horsing113215583hor_sing
hoseying1537193hoseying
hoveling15189593hoveling
hovering151911143hovering
jewing174411423__jewing
jonesing1636633jonesing
jowing174216043jo__wing
kotowing1634013kotowing
lacewing1435843lacewing
lording93115233lor_ding
lordling1077743lordling
lowering122210913lowering
lowing104623273lo__wing
mewing123914203__mewing
modeling12311073modeling
modeming1437103modeming
morning103215043mor_ning
morphing1637553morphing
morseling1238073morseling
moseying1436853moseying
mowing124119093mo__wing
northing12199063northing
obeying1336543_obeying
offering1536393offering
omening10310093_omening
opening1039923_opening
orating83520323_orating
orbing93312363_or_bing
ordering1039353_ordering
overing111918053_overing
owing96222723_o__wing
parawing14310583parawing
poring94227273por__ing
porking143515813por_king
portering122012303portering
porting103021783por_ting
powering142210803powering
preeing103817673_preeing
preying133114553_preying
pureeing1137273pureeing
reding83825563__reding
redwing122811983__redwing
renewing121910713renewing
resewing122712263resewing
rewin85623963__rewin_
rewind104715883__rewind
rewins95020823__rewins
rodeoing1037253rodeoing
rogering10310273rogering
roweling122811123roweling
rowing103623303__rowing
sewing103819623__sewing
shewing143812193_shewing
sinewing1267593sinewing
skewing15318723_skewing
slewing113311353_slewing
sobering111912783sobering
sorbing102815263sor_bing
soring74731883sor__ing
sorning83116813sor_ning
sorrowing1344873sorrowing
sorting83221813sor_ting
sowing104222913so__wing
spewing133110453_spewing
stewing113412493_stewing
strawing122411623strawing
strowing122310563strowing
tewing103914823__tewing
thrawing1535963thrawing
throwing1536723throwing
toeing74418473to_e_ing
tokening1336463tokening
torching142510083torching
torquing1833843torquing
toweling122910373toweling
towering122610873towering
towing103823193to__wing
treeing83414303_treeing
trowing113413703_trowing
unmewing1485913unmewing
unsewing1287433unsewing
viewing1437073_viewing
vowing133715273vo__wing
wording123014563wor_ding
working153813253wor_king
worming132811243wor_ming
worrying1534703worrying
worsening1345553worsening
worsting1267683worsting
worthing15178053worthing
wowing133915393wo__wing
yodeling1357673yodeling
yowing133715543yo__wing

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.1561145455.1
2DLD Change Limit1461622937.22020244.0
3Display Results2932930.1102663.6
 (SQL Overall)1786912937.48623870.0
 
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.