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

174 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
ploughs1352610(None) 
cloughs13517051cloughs
loughs105014771_loughs
plough12577561plough_
sloughs11497561sloughs
boughs125414372_boughs
choughs16576632choughs
clough12539132clough_
coughs125514542_coughs
doughs115912932_doughs
enoughs1144632enoughs
laughs10489022_laughs
lough95118482_lough_
ploughed15204302ploughed
plougher14214462plougher
ploughers15193922ploughers
plugs85213492pl_ug_s
roughs105416222_roughs
slough10539232slough_
sloughy14535802sloughy
soughs105115622_soughs
toughs105414992_toughs
troughs11698692troughs
abought1346153abought
almugs9396423almug_s
blogs85319233blo_g_s
blouses94014463blouses
boroughs1443803boroughs
bough115719313_bough_
bought125115643_bought
brought13308693brought
brughs12509063_brughs
chough15699253chough_
claught1335103claught
claughts1443383claughts
clogs85519553clo_g_s
cloths115512483clo_ths
clouds94612353clou_ds
clours85215093clou_rs
clouts87017203clou_ts
colugos1035693colugos
cough115819643_cough_
couths115715413_couths
dough105217383_dough_
dought114915523_dought
doughy14499843_doughy
drought12258883drought
droughts13245743droughts
drouths11436483drouths
eloigns8425353eloigns
enough1045763enough_
flogs95919963flo_g_s
flongs105010493flong_s
flours94414053flou_rs
flouts94315273flou_ts
fought135112403_fought
furloughs1641783furloughs
gloggs935033glo_ggs
glouts74414713glou_ts
glugs75214283gl_ug_s
gouges86318693_gouges
haughs13408563_haughs
heughs13516903_heughs
kiaughs1542283kiaughs
klongs11436603klong_s
kluges11389573kl_uges
laighs10508803_laighs
laugh94414373_laugh_
lochs106715513_lo_chs
lodges86820153_lodges
loges66534203_lo_ges
logos67225333_lo_gos
logs57343113_lo_g_s
longes75925573_longes
longs65527063_long_s
lotahs9479873_lotahs
louche115212663_louche
louies64525103_louies
louis57322323_lou_is
loumas84812333_loumas
lounges84811353_lounges
loupes84918053_loupes
loups75319623_lou_ps
lours55125293_lou_rs
louses66230283_louses
louts56330273_lou_ts
luges65928753_l_uges
lugs55233523_l_ug_s
mouths115214533_mouths
nought104713973_nought
noughts11478083_noughts
ought95221543__ought
oughts104710183__oughts
ouphs104311273__ouphs
pilous84717753pilou__s
pious74621273piou__s
plages94520153pl_ages
plagues103311063plagues
pledges113811583pledges
pleuras937413pleuras
plight123513363pl_ight
plights13299313pl_ights
plinths1236123plinths
plods85719293plo__ds
plonks124210423plo_nks
plops95920333plo__ps
plots75025673plo__ts
plotzes18317703plotzes
ploughing16203673ploughing
plovers123611833plovers
plowers123812243plowers
plows105419903plo__ws
ploys105816593plo__ys
plucks14379733pl_ucks
plug74915993pl_ug__
plumbs12459333pl_umbs
plumes104318133pl_umes
plumps124612613pl_umps
plums94619953pl_u_ms
plunges104011613plunges
plunks124711163pl_unks
plus66324833pl_u__s
pluses83618073pl_uses
plush105614713pl_ush_
plushes124313673pl_ushes
plushy14406973pl_ushy
pongs85526343p_ong_s
poohs103915713p_o_ohs
pouch124617083p_ouch_
pouches144116743p_ouches
pouchy16538663p_ouchy
pouffs14418123p_ouffs
poufs105616063p_ou_fs
poults84613483p_oults
pounds93714383p_ounds
pours74623183p_ou_rs
pouts75530323p_ou_ts
progs86624153pro_g_s
prongs94314483prong_s
pugh106619233p__ugh_
pugs76332773p__ug_s
rouges76022383_rouges
rough97819443_rough_
roughy137010863_roughy
rouths95416823_rouths
saughs104812053_saughs
scouths12527893scouths
shaughs14245283shaughs
sheughs14264533sheughs
sleighs11245673sleighs
sleuths1034743sleuths
slogs64521843slo_g_s
sloths94911893slo_ths
slouch11438523slouch_
slouches13208073slouches
slouchy15454843slouchy
sloughed13305583sloughed
slugs64618563sl_ug_s
sough95320463_sough_
sought106315063_sought
souths95216603_souths
splodges1234153splodges
sughs95313323__sughs
though139410783though_
thought14639143thought
thoughts15515613thoughts
tough97321993_tough_
toughy135911083_toughy
trough108512033trough_
ughs85410973___ughs
vughs12678743__vughs
wrought14276933wrought
yoghs125410593_yo_ghs
youths124510043_youths

Search took 7 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.406440125.6
2DLD Change Limit1340271746.45320769.7
3Display Results1741740.0632761.9
 (SQL Overall)1786911746.92225814.9
 
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.