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

221 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
tricksy1643658(None) 
trickly16369891trickly
tricks125319011tricks_
tricky154211471trick_y
bricks144614622bricks_
bricky17489092brick_y
crickey18418142crickey
cricks144316052cricks_
prickly18367892prickly
pricks144414262pricks_
pricky174210342prick_y
rickey154613972_rickey
ricks115126132_ricks_
stricks134310692stricks_
thickly19415572thickly
thicks154511992thicks_
ticks115823292t_icks_
tracks124818842tracks_
trices84826332trices_
trick115420692trick__
tricked144016162tricked
tricker134615522tricker
trickery17297342trickery
trickie132611032trickie
trickily1736232trickily
trickish1746792trickish
trickle133613442trickle
trocks123614632trocks_
trucks124711972trucks_
wricks154610622wricks_
brick134618153brick__
bricked164312063bricked
brickle15279933brickle
brinks124616313brinks_
briskly16165403briskly
brisks124611403brisks_
brocks145214153brocks_
chicks175317593chicks_
circusy14374593circusy
clicks145315113clicks_
crackly18397703crackly
cracks144817003cracks_
cracky175010223crack_y
crick135118753crick__
cricked164814283cricked
cricket154716953cricket
crikey15317783cri_key
crinkly16387523crinkly
crocks145118423crocks_
crucks144412583crucks_
dickey165913523_dickey
dicks125824693_dicks_
dicky154816243_dick_y
drecks13459203drecks_
drecky16486333dreck_y
drinks116810713drinks_
ericas8315463ericas_
fickly18318533_fickly
flicks154512993flicks_
freckly19124593freckly
frisks13479263frisks_
frisky16406673frisk_y
frocks154111213frocks_
hickey185011993_hickey
hicks145322173_hicks_
hoicks15378283hoicks_
icky136315753__ick_y
kicks104420083_kicks_
kicky135012333_kick_y
klicks11468723klicks_
licks115325393_licks_
mickey174211853_mickey
micks135525373_micks_
nicks114920493_nicks_
picks135226143_picks_
picky165416943_pick_y
prices104524543prices_
pricey134412633pric_ey
pricily142710283pricily
prick134317503prick__
pricked164613833pricked
pricker154013413pricker
pricket153616443pricket
prickle153611013prickle
pricy124814563pric__y
prinks124315383prinks_
prissy11347853pri_ssy
quickly2534073quickly
quicks21389303quicks_
racks115028853_racks_
recks115625133_recks_
rices75536153_rices_
richly1438003_richly
rick107334653_rick__
ricked136523623_ricked
rickety16478313_rickety
rickeys16548983_rickeys
ricksha1643123_ricksha
rinks94827103_rinks_
risks94917063_risks_
risky126311523_risk_y
rocks114626413_rocks_
rocky144513853_rock_y
rucks114422053_rucks_
shicksa1634103shicksa
sickly153110483_sickly
sicks115127623_sicks_
slickly1635853slickly
slicks124816113slicks_
snicks124312473snicks_
spicks144814993spicks_
sticks125118613sticks_
sticky154711343stick_y
strick124813203strick__
stricken1436893stricken
strickle1467793strickle
strictly1345813strictly
tackey154613083t_ackey
tacks115430133t_acks_
tacky145617443t_ack_y
talcky15294723talck_y
thacks154311923thacks_
thick145613353thick__
thicken16317873thicken
thicker163611023thicker
thickest17337303thickest
thicket163213073thicket
thickety20274103thickety
thickish2044603thickish
thickset17257133thickset
thinks134613363thinks_
tick106231223t_ick__
ticked134720523t_icked
ticker124321503t_icker
ticket124524853t_icket
tickle124616743t_ickle
tics65729633t_ic_s_
tinkly134811153t_inkly
tipsy106010503t_i_psy
torics85118353toric_s_
tracery12399793tracery
traces85329933traces_
track114823013track__
tracked143716133tracked
tracker133515173tracker
trackway20113783trackway
tracts85019073tracts_
traiks104013713traiks_
tranks104017763tranks_
treks96016853tr_eks_
tressy9448553tr_essy
triacs83913223triacs_
triads74513533triads_
trials64319883trials_
tribes85119023tribes_
trice75127493tric__e
triced95518673tric_ed
tricep103911073tric_ep
triceps11267343triceps
tricing103417353tricing
trickers143812813trickers
trickier143010233trickier
trickiest1549023trickiest
tricking152714513tricking
trickishly2251973trickishly
trickled152610433trickled
trickles143013763trickles
tricksier15275243tricksier
trickster15265703trickster
triclad1037443triclad
tricorn937963tricorn
tricot8317753tric_ot
tricots9311563tricots
triens65417543triens_
triers64321523triers_
tries55742813tri_es_
trigly103810943tri_gly
trigos74214173trigos_
trigs65423063tri_gs_
trike95320163tri_k_e
trikes105419493tri_kes
trilby1144973tri_lby
trills64319853trills_
trilogy1136013trilogy
trimly114410893tri_mly
trims75021473tri_ms_
trinary1039173trinary
trines64132563trines_
trinity10310843trinity
trinket11314813trinket
triols66117803triols_
trios55528093tri_os_
triose64715383tri_ose
tripacks1664893tripacks_
tripes85324873tripes_
triply114211023tri_ply
tripody13395983tripody
tripos84014923tripos_
trippy13457803tri_ppy
trips74923363tri_ps_
trisomy1235943trisomy
tritely1039003tritely
tritest7315273tritest
troaks104410603troaks_
trock114817603trock__
trocked144312243trocked
truces84916333truces_
truck116115463truck__
trucked143910813trucked
trucker134010733trucker
truckle13358863truckle
trunks10429753trunks_
tucks114721123t_ucks_
twinkly1733913twinkly
wicks144619363_wicks_
wracks154711113wracks_
wrecks15418883wrecks_
wrick144013393wrick__
wricked174910193wricked
wrinkly17295753wrinkly
yoicks15375933yoicks_

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 Filter1786911340270.393454684.5
2DLD Change Limit1340272216.59320328.7
3Display Results2212210.0802762.5
 (SQL Overall)1786912217.06625288.8
 
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.