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

464 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
trouty9521179(None) 
grouty104710981grouty
trout57332571trout_
trouts66116621trouts
agouty10366912agouty
croupy13458732croupy
croute84617272croute
drouth104410102drouth
drouthy14395172drouthy
frosty124710632frosty
frouzy21395282frouzy
gouty95217362_gouty
grotty10389832grotty
grout65330422grout_
grouts75015612grouts
pouty107018812_pouty
rooty86423022_rooty
roupy106112712_roupy
rout46153282_rout_
route55132072_route
routh86423072_routh
routs57133412_routs
snouty9419952snouty
throaty13428482throaty
tout46753822t_out_
touts54830392t_outs
treaty94414352treaty
trolly94012352trolly
trophy1438282trophy
trot46351312tro_t_
troth85622202tro_th
trots56629942tro_ts
trotyl9236672tro_tyl
trough108512022trough
troupe84812432troupe
trowth1277882trowth
troy77429682tro__y
truly84111552tr_uly
trusty94710112trusty
truth85214152tr_uth
tryout9410752tryout_
tryouts1035292tryouts
about75229083about_
agouti7388763agouti
arbute8311043arbute
argufy1344093argufy
armoury12376233armoury
around72712413around
arouse65019983arouse
arty77531313ar__ty
atrocity1347213atrocity
atrophy1546183atrophy
beauty115410163beauty
blotty11178343blotty
blousy11459123blousy
booty106125913_booty
borty105522833_borty
bounty113411073_bounty
bousy104917843_bousy
bout66353293_bout_
bouts75131313_bouts
bratty1159683bratty
brolly114510853brolly
bronzy20306713bronzy
broody124510083broody
broomy13449953broomy
brosy106115383bro_sy
broth106521093bro_th
brothy14519623brothy
browny144510043browny
brut66537963br_ut_
brute75321783br_ute
bruts75922953br_uts
clotty11208263clotty
cloudy12517803cloudy
clout75330463clout_
clouts87017203clouts
county114313323_county
couth106122483_couth
crafty14478913crafty
croaky15528483croaky
croft105622683croft_
crofts114910593crofts
crony105918673cro_ny
crouch133910203crouch
croup95616783crou_p
croupe105114433croupe
croups104312553croups
crouse84619363crouse
croutes94815643croutes
crouton947133crouton
crowdy15467173crowdy
crusty114911343crusty
deputy12426713deputy
dorty96220813_dorty
dotty94516103_dotty
doty86128223_do_ty
drafty13638933drafty
drifty13418223drifty
droit65127123droit_
droits74314313droits
drolly105411673drolly
drooly104911073drooly
droopy12458243droopy
dropsy12497473dropsy
dropt86924433dropt_
drosky14486163drosky
drossy10528473drossy
droughty16304473droughty
drouk1039433drou_k
drouks1137123drouks
drouths11436483drouths
drowsy13487903drowsy
duty85321453__duty
floaty124210943floaty
floury12449573floury
flout86226203flout_
flouts94315273flouts
fluty114415643_fluty
footy115820533_footy
forty114824273_forty
fretty1249223fretty
froggy1434493froggy
front85029223front_
fronts94415793fronts
frost84727833frost_
frosts94214623frosts
froth115919283fro_th
frothy15578373frothy
frowsty16464983frowsty
frowsy15498273frowsy
frowzy24485793frowzy
fruity12429693fruity
ghosty13467213ghosty
glout65925813glout_
glouts74414713glouts
gout56646003_gout_
gouts64826173_gouts
gritty10338403gritty
groat65531973groat_
groats74816653groats
grody103412063gro_dy
groggy1234803groggy
groovy13375403groovy
groszy19395703groszy
grot55942053gro_t_
grots65025853gro_ts
grotto7349813grotto
grouch12318473grouch
grouchy16294243grouchy
ground82310273ground
group85413923grou_p
groups94210513groups
grouse74315023grouse
grouted94111503grouted
grouter84412523grouter
growly13499173growly
growth1377383growth
growthy1773283growthy
hooty115022433_hooty
irony85015903iro_ny
jolty155713033_jolty
jotty155012603_jotty
knotty13315223knotty
knout95018263knout_
knouts10438313knouts
koruny1334443koruny
kraut95221403kraut_
krauts10418513krauts
lofty115813303_lofty
loury85716753_loury
lousy84617083_lousy
lout45952143_lout_
louts56330273_louts
mousy106716943_mousy
mouth105420293_mouth
mouthy14409063_mouthy
out38072153__out_
outby10411533__outby
outs45746963__outs
plotty11208853plotty
potty105621003_potty
pout65752553_pout_
pouts75530323_pouts
pretty11510873pretty
probity14299683probity
pronto8313993pronto
prost75434103prost_
prosy106319253pro_sy
protyl11308213pro_tyl
proud84615483prou_d
proudly1336323proudly
proxy175011013pro_xy
pruta7314243pr_uta
ratty84819593_ratty
reroute7313963reroute
rocky144513853_rocky
roily86121113_roily
rooky126117623_rooky
roomy107118063_roomy
root45655923_root_
roots55933673_roots
ropey106021873_ropey
ropy96323413_ro_py
rosy76024873_ro_sy
rot37282953_ro_t_
rota45834343_ro_ta
rote46249023_ro_te
roti46332923_ro_ti
rotl45029683_ro_tl
roto45935053_ro_to
rots46454093_ro_ts
rotte54625933_rotte
roue45941743_rou_e
rouen54920903_rouen
roues56039353_roues
rouge65423443_rouge
rough97819433_rough
roughy137010853_roughy
round64318433_round
roup66627693_rou_p
roups75118903_roups
rouse56634703_rouse
roust55532063_roust
rousts617016723_rousts
routed75624333_routed
router65025843_router
routes66129313_routes
rouths95416823_rouths
roux117419363_rou_x
rowdy125711533_rowdy
rowth115713233_rowth
ruby97819943_r_uby
ruly76323143_r_uly
runty86119043_runty
rusty85221053_rusty
rut35560523_r_ut_
ruth76825993_r_uth
ruts44541493_r_uts
rutty85617803_rutty
scout75031453scout_
scouth115011153scouth
scouts84817943scouts
shorty124313193shorty
shout85433163shout_
shouts94017713shouts
snooty94211503snooty
snotty9489193snotty
snout54530633snout_
snouts64915863snouts
softy115414483_softy
sooty84924833_sooty
soupy106115403_soupy
south85223573_south
sporty115112493sporty
spotty11448573spotty
spout75029633spout_
spouts85115113spouts
sprout8419403sprout_
sprouts949983sprouts
stoury9529943stoury
stout57434053stout_
stoutly1035833stoutly
stouts65019003stouts
stroppy14205093stroppy
stroud7310383strou_d
strouds837793strouds
stroy87720393stro__y
strut56030733str_ut_
struts65616803str_uts
tarot55943933taro_t_
tarots66422993taro_ts
tarty86328183t_arty
tasty84820313t_asty
tatouay1044113tatouay
tatty84720183t_atty
taut47048963t_aut_
tautly9499503t_autly
tauts56125513t_auts
tenty86121603t_enty
tenuity1037453tenuity
tenuti638973tenuti
tenuto648743tenuto
testy85419063t_esty
thirty12378403thirty
thorny12509843thorny
thou76722213thou__
thoued10429003thoued
though139410763though
thous86017253thou_s
thrifty1634193thrifty
throat94819753throat_
throats104612173throats
through141647513through
titty85316653t_itty
toady96814343t_oady
toasty9509563toasty
toby96322293t_o_by
today96416953t_oday
toddy106812423t_oddy
tody86327213t_o_dy
toffy145310283t_offy
toft77441653t_oft_
tofts84919243t_ofts
toit46353063t_oit_
toits55327473t_oits
tokay125513053t_okay
tommy124712233t_ommy
toney86027413t_oney
tony75635153t_o_ny
toot45958883t_oot_
tooth88020183t_ooth
toothy12529693toothy
toots55331873t_oots
tootsy9437983tootsy
torchy14549533torchy
torosity1147243torosity
torot56139943torot_
toroth95512963toroth
torous64319023torou_s
tort46967463t_ort_
torta55925353t_orta
torte55431703t_orte
torts56138123t_orts
torula6610393torula
torus54329763toru_s
tory75840543t_o_ry
tost48351923t_ost_
tot38884773t_o_t_
tote46643673t_o_te
tots46654123t_o_ts
touch106519393t_ouch
touchy145010503t_ouchy
tough97321983t_ough
toughy135911073t_oughy
tour45530373t_ou_r
tours55325863t_ours
touse55430673t_ouse
touted74419743t_outed
touter63821033t_outer
towny116114493t_owny
towy105325473t_o_wy
toy69655193t_o__y
tract75635713tract_
tracts85019073tracts
trait56940843trait_
traits65121983traits
trampy13499253trampy
tranny94210863tranny
trapt76433393trapt_
trashy12509053trashy
trauma838803trauma
tray77632593tr__ay
treat56240353treat_
treats64821693treats
trebly1138973trebly
trendy10469603trendy
tressy9448553tressy
tret46653533tr_et_
trets55928023tr_ets
trey77228793tr__ey
tribute937313tribute
tricky154211473tricky
trigly103810943trigly
trilby1144973trilby
trimly114410893trimly
trinity10310843trinity
triply114211023triply
trippy13457803trippy
triste63818643triste
trite54730033tr_ite
triune64210183triune
triunity1145073triunity
troak95213573tro_ak
troaks104410593troaks
trocar848763trocar
troche113112513troche
trock114817603tro_ck
trocks123614633trocks
trod57627953tro__d
trode65322853tro_de
trog57628213tro__g
trogon73611753trogon
trogs67022603tro_gs
troika1035493troika
trois57226093tro_is
troke94821053tro_ke
troked114114583troked
trokes104019263trokes
troll54416533tro_ll
trolley10328753trolley
trolls64613943trolls
tromp95815803tro_mp
trompe105611263trompe
tromps104911703tromps
trona54118953tro_na
tronas63816893tronas
trone55131863tro_ne
trones65629283trones
troop76417533tro_op
troops85712773troops
trooz145016153tro_oz
trop66833303tro__p
trope75725803tro_pe
tropes84824353tropes
tropic103014193tropic
tropin83316753tropin
troths95414153troths
trotted83711283trotted
trotter73312253trotter
trotyls10236033tro_tyls
trouble957703trouble
troughs11698673troughs
trounce936823trounce
trouped103910973trouped
trouper93811413trouper
troupes94112843troupes
trouser73812463trouser
troutier8277143troutier
trove85221923tro_ve
trover95014663trover
troves94719113troves
trow78031423tro__w
trowed104714653trowed
trowel94211463trowel
trows88826183tro_ws
trowths1365023trowths
troys86418613tro_ys
truce75118693tr_uce
truck116115463tr_uck
true46725853tr_u_e
trued65117693tr_ued
truer54916643tr_uer
trues54925323tr_ues
trug55720043tr_u_g
trugs65516803tr_ugs
trull54012673tr_ull
trump95615123tr_ump
trunk94713043tr_unk
truss54916923tr_uss
trust55426853tr_ust
trusts64714433trusts
truths9449503tr_uths
try66529673tr___y
tryst84716223tryst_
tryste9399583tryste
trysts9448793trysts
tufty114810413t_ufty
turnout7410283turnout_
turnouts845403turnouts
tut36758093t__ut_
tuts45838453t__uts
tutty85217023t_utty
tutu48423173t__utu
twenty1236223twenty
twisty12426863twisty
vrouw11507343vrou_w
vrouws12494743vrouws
wristy12509703wristy
wrote84717483wro_te
wroth116815883wro_th
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.1561145455.1
2DLD Change Limit1127164646.11018447.8
3Display Results4644640.2661744.4
 (SQL Overall)1786914646.53227356.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.