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

379 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
trucking15331016(None) 
rucking143216671_rucking
tracking153715461tracking
tricking152714511tricking
trocking153612421trocking
trucing103211841truc_ing
truckings16235021truckings
truckling1645071truckling
tucking143415181t_ucking
arcking145811962ar_cking
bricking173911402bricking
bucking163617572_bucking
chucking20379502chucking
clucking17429992clucking
cracking174013902cracking
cricking173412652cricking
crocking174313442crocking
ducking154315052_ducking
eructing112110172eructing
frocking18309572frocking
fucking173212282_fucking
lucking143615832_lucking
mucking163213822_mucking
plucking17357722plucking
pricking173212602pricking
racking144323662_racking
recking144319922_recking
ricking143920232_ricking
rocking143619632_rocking
ruching133612932_ruching
ruckling15258572_ruckling
shucking18339432shucking
sucking143217412_sucking
tacking144421482t_acking
talcking1567082talcking
thacking183110042thacking
thunking16196952thunking
ticking143218752t_icking
touching143211342touching
tracing103720152trac_ing
trackings16247542trackings
traiking132511972traiking
trekking1235542trekking
tricing103417352tric_ing
trickling1647722trickling
troaking133310972troaking
troking123514102tr_oking
truckline1544912truckline
trudging11266442trudging
trueing83410182tru_eing
truing73913932tru__ing
trumping13308732trumping
trussing9268652trussing
trusting93411652trusting
tusking124212062t_usking
wracking18349962wracking
wrecking18328152wrecking
wricking18349492wricking
yucking173211692_yucking
arching136216693ar_ching
arcing95819643ar_c_ing
attacking1635323attacking
backing165523443_backing
baulking1536003baulking
becking164416073_becking
blacking174213603blacking
blocking174510573blocking
bracing123817613brac_ing
braking143917713br_aking
breaking153914253breaking
brisking15329473brisking
broking143514823br_oking
brooking153710703brooking
brucin1049133bruc_in_
brucine1138273bruc_ine
brucins1158003bruc_ins
bruising11279143bruising
bruiting11259973bruiting
brunching17316483brunching
brushing14359963brushing
bruting102612993bru_ting
bruxing17236823bru_xing
buckling17259113_buckling
bulking143815123_bulking
bunking144016193_bunking
burking143716323_burking
busking144116573_busking
caulking1536803caulking
checking20379203checking
chocking204011013chocking
chuckling2144193chuckling
chunking18328053chunking
clacking173313493clacking
clicking173610983clicking
clocking174312413clocking
clunking15329433clunking
cocking163619983_cocking
couching163213263couching
crackings18346843crackings
crackling18157003crackling
cranking154613073cranking
creaking153414123creaking
croaking153712163croaking
crooking153611343crooking
crouching1746383crouching
crudding1335723crudding
cruising112610153cruising
crumbing15267813crumbing
crumping15319903crumping
crunching17297003crunching
crushing143010053crushing
crusting113612793crusting
crutching17216073crutching
decking153915593_decking
deucing1139393deuc_ing
dicking153617613_dicking
docking153615013_docking
douching15349843douching
drinking14308913drinking
drouking1436443drouking
drubbing14286053drubbing
drudging12256233drudging
drugging12326443drugging
drumming14265783drumming
duckling16247703_duckling
ducting113713593_ducting
duking124715133_du_king
dunking133813263_dunking
dusking133912053_dusking
educing1137683educ_ing
erecting112415063erecting
erlking1236703er_lking
erupting11218443erupting
flacking184311793flacking
flecking18408233flecking
flicking184110043flicking
flocking183410873flocking
fluking154410513flu_king
flunking16317773flunking
franking164310863franking
freaking163611453freaking
freckling1934703freckling
frisking16268363frisking
frugging14317053frugging
fruiting12229063fruiting
funking154013023_funking
gecking154111363_gecking
gracing113216443grac_ing
grokking1334813grokking
grouching1644943grouching
grubbing14295403grubbing
grudging12255993grudging
grueling1078273grueling
gruffing1635273gruffing
grumping14266903grumping
grunting10269583grunting
grutching16224373grutching
hacking173720613_hacking
hocking173417243_hocking
hoicking1836053hoicking
hulking153910983_hulking
husking154312053_husking
irking114611753ir__king
jacking214515263_jacking
jauking19418323jau_king
jouking19307613jou_king
juking183810473_ju_king
junking193910073_junking
kecking134111883_kecking
kicking133314023_kicking
knacking14296713knacking
knocking14245943knocking
knuckling1542753knuckling
lacking143821543_lacking
licking144118283_licking
locking143718153_locking
lurching14277333lurching
lurking123710853_lurking
mocking163614453_mocking
mouching163110583mouching
necking143913893_necking
nicking143516323_nicking
nocking143615113_nocking
nuking113411253_nu_king
ouching134314903_ouching
outrocking1747053outrocking
packing164420723_packing
pecking164017783_pecking
picking163418333_picking
plunking15328483plunking
pocking163916763_pocking
pouching163210413pouching
pranking153813383pranking
pricing123417343pric_ing
prickings18315653prickings
prickling1836533prickling
prinking153212453prinking
pruning10311733pru_ning
puking133913063_pu_king
quacking2436743quacking
quaking2139313_quaking
racing95030533_rac_ing
raking114728423_r_aking
ranking124320883_ranking
reeking123318643_reeking
reracking1639313reracking
retracking1738163retracking
ricing94822763_ric_ing
risking123914243_risking
rockling15259383_rockling
rooking123517363_rooking
rubbing123412273_rubbing
rubying13297933_rubying
ruchings14287073_ruchings
ruffing143210843_ruffing
rugging102512763_rugging
ruing67221053_ru__ing
ruining83514883_ruining
ruling73219553_ru_ling
runkling13217613_runkling
running83514593_running
rushing113817703_rushing
rusting83821263_rusting
rutting82718043_rutting
ryking14348113_r_yking
sacking144122703_sacking
saucing10311003sauc_ing
sculking15307913sculking
shacking184014083shacking
shocking184311543shocking
shuckings19273853shuckings
sicking143720173_sicking
skulking12245903skulking
skunking12256653skunking
slacking153914133slacking
slicking153712593slicking
smacking173510763smacking
smocking17349103smocking
snacking153411703snacking
snicking153610233snicking
socking143518603_socking
specking17359733specking
sprucing1336893spruc_ing
spunking15258063spunking
stacking154215083stacking
sticking153513463sticking
stocking152912503stocking
streaking142010323streaking
streeking14217453streeking
strickling1744953strickling
striking133012233str_iking
stroking132610943str_oking
strucken1444323strucken_
strumming1454413strumming
strunting1037873strunting
strutting1037003strutting
suckling152410023_suckling
sulking124514313_sulking
tackling153211123t_ackling
taking114725953t__aking
talcing103111633talc_ing
talking123815823t_alking
tanking123918793t_anking
tarmacking1944233tarmacking
tasking124616323t_asking
taunting93510933taunting
tauting83316383tau_ting
teaching143612603teaching
thanking16409523thanking
thinking16289863thinking
thrumming1742903thrumming
thrusting1335003thrusting
thudding1433983thudding
thumbing16245513thumbing
thumping16296713thumping
thwacking2253193thwacking
ticcing12308633t_iccing
tickings15368583t_ickings
tickling15309433t_ickling
tincting1148883tincting
toking114420723t__oking
torching142510083torching
toughing13278553toughing
touring82915193tou_ring
tousing82916993tou_sing
tousling938793tousling
touting84118453tou_ting
touzling1835503touzling
trachling1537823trachling
tracings112910413trac_ings
trading93517973tr_ading
traducing1374013traduc_ing
trailing92916093trailing
training93015863training
tramming13279343tramming
tramping132711273tramping
trancing112812023trancing
trapping132911393trapping
trashing122613223trashing
trauchling1643473trauchling
trawling122710783trawling
treading103515333treading
treating92519613treating
trebling1139873trebling
treeing83414303tr_eeing
trenching15227653trenching
trending103012833trending
triaging102610543triaging
trichina1348093trichina
trickie132611033tricki_e
trickier143010233trickier
trickily1736233trickily
trickish1746793trickish
trifling122411503trifling
trigging11299583trigging
trilling92815963trilling
trimming13318653trimming
trining82919213tr_ining
tripling112712553tripling
tripping133210923tripping
trithing122811773trithing
trolling93212493trolling
tromping13319593tromping
trooping112710273trooping
trothing122410843trothing
trotting92510913trotting
troubling1234933troubling
trouncing1235153trouncing
trouping11249503trouping
trowing113413703tr_owing
truanting1035603truanting
truck116115463truck___
truckage1543633truckage
trucked143910813truck_ed
trucker134010733truck_er
truckers14279013truckers
truckful1743073truckful
truckle13358863truck_le
truckled15327313truckled
truckler14297453truckler
truckles14319383truckles
trucklines1644293trucklines
truckman1643153truckman
truckmen1643373truckmen
trucks124711973truck__s
truncating1344233truncating
trundling1135003trundling
trussings10224033trussings
trying104214073tr__ying
trysting12267053trysting
tsking114210423t__sking
tubbing123510093t_ubbing
tubing93813093t_u_bing
tuckering1635693t_uckering
tufting11289873t_ufting
tugging102611233t_ugging
tumping123114243t_umping
tuning74016843t_u_ning
tunning83514453t_unning
tupping123411663t_upping
turfing113010053t_urfing
turning83713183t_urning
turtling9238833turtling
tushing114214013t_ushing
tutting83515913t_utting
tweaking1635883tweaking
untracking1746933untracking
untucking1644693untucking
vouching17308233vouching
wauking153410013wau_king
whacking21377483whacking
wicking173414773_wicking
wreaking163010213wreaking
wreckings19233683wreckings
yacking174315683_yacking
yeuking15286123yeu_king
yocking173712373_yocking
yukking14374733_yukking
zincking2435463zincking

Search took 9 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 Limit1461623797.73318901.1
3Display Results3793790.1562429.5
 (SQL Overall)1786913798.04522211.4
 
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.