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

252 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
agouty1036691(None) 
agouti7388771agouti
gouty95217361_gouty
about75229082about_
agony96415652ago_ny
agoutis8286872agoutis
gout56646002_gout_
gouts64826172_gouts
grouty104710982grouty
pouty107018812_pouty
ragout7317182ragout_
ragouts838542ragouts
snouty9419952snouty
trouty95211792trouty
abort76133583abort_
aborts84916183aborts
abound9239863abound
abut66834953a_but_
abuts75417073a_buts
acuity1139373acuity
acute74720363a_cute
adopt81219743adopt_
adopts998083adopts
afoot8420113afoot_
afoul8510193afou_l
agate66525153ag_ate
agedly1136463agedly
agency1237033agency
agent65829643agent_
agentry11165753agentry
agents74816293agents
agility1148653agility
agist66325583agist_
agists75713173agists
agita6315423ag_ita
aglet65534143aglet_
aglets73915683aglets
agley96917333ag_ley
agly86821803ag__ly
agnate73314883agnate
ago48845523ago___
agog68019003ago__g
agon56531883ago__n
agonal7410053agonal
agone65924553ago_ne
agones75719863agones
agonic93515143agonic
agons66423783ago_ns
agora6914333ago_ra
agorae7511203agorae
agoras7613343agoras
agorot7415003agorot
agoroth1145143agoroth
agouties9337693agouties
aground9216183aground
ague55725923ag_u_e
agues64919053ag_ues
ahoy101919183aho__y
aloft8423433aloft_
aloud65018073alou_d
amity10416093a_mity
amort75832203amort_
amount8414483amount
amounts937043amounts
amour75014853amou_r
amours83512663amours
annuity1045543annuity
anomy105113393ano_my
aorta55922573a_orta
aport75432173aport_
arbute8311043arbute
argosy1036423argo_sy
argot67728653argo_t_
argots74116033argo_ts
argufy1344093argufy
armoury12376233armoury
around72712413around
arouse65019983arouse
arty77531313a__rty
astute6310763astute
atomy107415193ato_my
atony87218853ato_ny
atopy106813393ato_py
augury10366663augury
aunty85919813a_unty
auto47432083a__uto
avouch1434833avouch
azote144416343azo_te
azoth17389903azo_th
beauty115410163beauty
blotty11178343blotty
blousy11459123blousy
booty106125913_booty
borty105522833_borty
bounty113411073_bounty
bousy104917843_bousy
bout66353293_bout_
bouts75131313_bouts
bugout9311863bugout_
bugouts1036193bugouts
clotty11208263clotty
cloudy12517803cloudy
clout75330463clout_
clouts87017203clouts
county114313323_county
couth106122493_couth
croupy13458733croupy
croute84617273croute
dacoity1366183dacoity
dakoity1543423dakoity
deputy12426713deputy
dorty96220813_dorty
dotty94516103_dotty
doty86128223_do_ty
drouth104410103drouth
drouthy14395173drouthy
dugout8310363dugout_
dugouts935043dugouts
duty85321453__duty
faggoty1542863faggoty
fagot9323403fago_t_
fagots1039963fago_ts
floaty124210943floaty
floury12449573floury
flout86226203flout_
flouts94315273flouts
fluty114415643_fluty
footy115820533_footy
forty114824273_forty
frosty124710633frosty
frouzy21395283frouzy
gaiety10119373gaiety
gamut8322983gamut_
gamuts958783gamuts
gaudy106611463_gaudy
gauzy18489213_gauzy
gayety13116383gayety
ghosty13467213ghosty
glout65925813glout_
glouts74414713glouts
gluey95715263_gluey
glut56331293_glut_
glute66020903_glute
gluts66120133_gluts
goat56250833_goat_
goats65527303_goats
goby106021083_go_by
godly104913293_godly
golly95121103_golly
gomuti936553_gomuti
goody105620393_goody
gooey95522863_gooey
goofy124915623_goofy
gooky135818033_gooky
goony95519783_goony
goopy115816623_goopy
goosy96018883_goosy
gorsy95915783_gorsy
gory86129663_go_ry
got49870443_go_t_
goth86825083_go_th
gouge78220063_gouge
gourd71011903_gourd
goutily1137933_goutily
goy77844553_go__y
grotty10389833grotty
grout65330423grout_
grouts75015613grouts
gusty95119573_gusty
gut46753853_g_ut_
guts56637253_g_uts
gutsy96412843_g_utsy
gutty94516993_gutty
guy75728943_g_u_y
hagbut1278923hagbut_
hagbuts1354933hagbuts
hangout11411393hangout_
hangouts1236183hangouts
hooty115022443_hooty
jolty155713033_jolty
jotty155012603_jotty
knotty13315223knotty
knout95018263knout_
knouts10438313knouts
layout9513703layout_
layouts1046483layouts
lofty115813303_lofty
loury85716753_loury
lousy84617083_lousy
lout45952143_lout_
louts56330273_louts
maggoty1444013maggoty
magot8326393mago_t_
magots9312363mago_ts
maguey1236833mag_uey
mahout11415813mahout_
mahouts1237143mahouts
mousy106716943_mousy
mouth105420293_mouth
mouthy14409063_mouthy
out38072153__out_
outby10411533__outby
outs45746963__outs
payout11714653payout_
payouts1247303payouts
pigout9314613pigout_
pigouts1037593pigouts
plotty11208853plotty
potty105621003_potty
pout65752553_pout_
pouts75530323_pouts
ragouted1034423ragouted
rooty86423023_rooty
roupy106112713_roupy
rout46153283_rout_
route55132073_route
routh86423073_routh
routs57133413_routs
sagbut959753sagbut_
sagbuts1065223sagbuts
savoury13365873savoury
scout75031453scout_
scouth115011153scouth
scouts84817943scouts
shorty124313203shorty
shout85433173shout_
shouts94017723shouts
snooty94211513snooty
snotty9489203snotty
snout54530633snout_
snouts64915873snouts
softy115414483_softy
sooty84924843_sooty
soupy106115403_soupy
south85223573_south
sporty115112493sporty
spotty11448583spotty
spout75029633spout_
spouts85115113spouts
stoury9529943stoury
stout57434053stout_
stoutly1035833stoutly
stouts65019003stouts
tatouay1044113tatouay
tout46753823_tout_
touts54830393_touts
trout57332573trout_
trouts66116633trouts
vapoury15284803vapoury
youth115315043_youth
zloty17399793zlo_ty
zooty175415353_zooty

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162525.67019879.4
3Display Results2522520.0803150.0
 (SQL Overall)1786912526.12629169.3
 
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.