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

343 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
truckers1427901(None) 
trackers143512851trackers
trickers143812811trickers
trucker134010731trucker_
trucklers15295581trucklers
tuckers134014351t_uckers
buckers153517452_buckers
crackers164111722crackers
duckers143214712_duckers
fuckers163611592_fuckers
muckers153612802_muckers
pluckers16316552pluckers
prickers163710672prickers
puckers153514672_puckers
rackers134320452_rackers
rockers133916552_rockers
shuckers17388132shuckers
suckers133717622_suckers
tackers134319622t_ackers
tickers133617722t_ickers
touchers133611212touchers
tracers94917842trac_ers
tracker133515172tracker_
trekkers1133802trekkers
tricker134615522tricker_
trickery17297342trickery
truces84916332truc_e_s
trucked143910812trucke_d
truckler14297452truckler_
truckles14319382truckles
trucks124711972truck__s
trudgers10256862trudgers
trussers8348282trussers
trusters83112262trusters
tucker124316952t_ucker_
tuckets134810332t_uckets
tuskers113710042t_uskers
wreckers17315972wreckers
archers124414573ar_chers
attackers15144013attackers
backers153821883_backers
bickers154316553_bickers
blockers16398793blockers
bluchers15359033bluchers
bracers114616703brac_ers
brackens16327923brackens
brackets163310433brackets
breakers143810973breakers
brockets16328123brockets
brokers133111913br_okers
bruisers10307953bruisers
bruiters10329143bruiters
brunchers16296253brunchers
brushers134210573brushers
brusker13437853brusker_
bucker145420463_bucker_
buckets153811693_buckets
bucklers16349503_bucklers
bunkers133715953_bunkers
burkers133716623_burkers
buskers133414093_buskers
caulkers14375653caulkers
checkers19317843checkers
chucklers2034443chucklers
chukkers1633483chukkers
clackers163911703clackers
clickers163910203clickers
clockers16369813clockers
clunkers14327553clunkers
cockers153618333_cockers
couchers153513863couchers
cracker153114173cracker_
crickets16418123crickets
croakers14288523croakers
crockery19356603crockery
crockets16339543crockets
cruces105117543cruc_e_s
crucifers1643333crucifers
crucks144412583cruck__s
cruisers10438273cruisers
crullers1047303crullers
crumbers14338243crumbers
crunchers16316243crunchers
cruppers14317323cruppers
crushers134010093crushers
dackers143417043_dackers
deckers144413833_deckers
dickers144117663_dickers
dockers143715003_dockers
drinkers13277823drinkers
drubbers13386033drubbers
drudgers11326853drudgers
drummers13316163drummers
drunker12326633drunker_
druthers1275793druthers
ducker134317993_ducker_
duikers12369383_duikers
dunkers123512193_dunkers
erecters102611613erecters
flickers17338883flickers
flunkers15347533flunkers
frankers15348353frankers
friskers15337373friskers
fruiters11328183fruiters
fucker153414423_fucker_
funkers143712063_funkers
grocers103511253groc_ers
grubbers13316203grubbers
grudgers11266753grudgers
gruelers936173gruelers
grungers10298503grungers
grunters9359033grunters
hackers164619043_hackers
hockers163915913_hockers
hunkers143314333_hunkers
huskers143510043_huskers
ickers123914183__ickers
jackers204214453_jackers
junkers184010863_junkers
kickers124013293_kickers
knackers13286843knackers
knickers13306723knickers
knockers13285733knockers
knucklers1483043knucklers
krullers1234133krullers
lackers134120543_lackers
lickers134118253_lickers
lockers133516923_lockers
lunkers113414603_lunkers
lurchers13307153lurchers
lurkers113910083_lurkers
mockers153812943_mockers
mucker143816393_mucker_
neckers134210463_neckers
nickers134415093_nickers
ockers123813903__ockers
packers153818893_packers
peckers153312673_peckers
pickers153718093_pickers
plucker15368243plucker_
plunkers14328333plunkers
pricers113915063pric_ers
pricker154013413pricker_
prickets16329083prickets
prinkers143010383prinkers
pruners93710723pru_ners
pucker143817633_pucker_
puckery18306263_puckery
punkers133714853_punkers
quakers20309693_quakers
racers84725433_rac_ers
racker124824553_racker_
rackets134916873_rackets
rakers104123573_r_akers
rankers113217463_rankers
reekers113613143_reekers
ricers84120993_ric_ers
rickets134915093_rickets
rickeys16548983_rickeys
riskers114011993_riskers
rocker124319573_rocker_
rockery16439253_rockery
rockets134615363_rockets
rubbers113913193_rubbers
ruches114819583_ruche_s
rucked134718763_rucke_d
ruckles133414603_ruckles
rucks114422053_ruck__s
ruckus12407793_ruck_us
rudders93210653_rudders
ruers515019413_ru__ers
ruggers94612313_ruggers
ruiners74213023_ruiners
rulers64317093_ru_lers
rummers113513653_rummers
runners74212453_runners
rushers103816103_rushers
sackers133820223_sackers
saucers93712133sauc_ers
sauciers1076733sauciers
sculkers14306933sculkers
shickers173012823shickers
shockers17319463shockers
shucker163710103shucker_
skulkers11334923skulkers
slackers143812743slackers
slickers143112553slickers
smackers16318713smackers
snackers143010223snackers
snickers143010963snickers
stackers143413563stackers
stickers142913033stickers
stockers143411073stockers
streakers13218133streakers
streekers13195803streekers
strikers123611293str_ikers
strokers123910903str_okers
strucken1444323strucke_n
strummers1333693strummers
strutters955693strutters
sucker124120663_sucker_
sucklers14379963_sucklers
sulkers113613343_sulkers
tacker124224503t_acker_
tackets134914363t_ackets
tacklers143010773t_acklers
takers103923743t__akers
talkers113513213t_alkers
tankers113416913t_ankers
taunters8259273taunters
teachers133212393teachers
thankers15297833thankers
thickens17266413thickens
thicker163611023thicker_
thickets17287083thickets
thinkers15308703thinkers
thrummers1642413thrummers
thrusters1245333thrusters
thumpers15365713thumpers
thunders1236953thunders
thwackers2142223thwackers
ticker124321503t_icker_
tickets134113683t_ickets
ticklers14339303t_icklers
tinkers113517143t_inkers
tochers123413093t_ochers
tokers104818893t__okers
toucher124814353toucher_
touches125118343touche_s
tourers73512743tou_rers
touters74018353tou_ters
tracer84820233trac_er_
tracery12399793trac_ery
traces85329933trac_e_s
tracheas13410273tracheas
tracked143716133tracke_d
trackless15246723trackless
tracks124818843track__s
tractors10312563tractors
traders84316953tr_aders
traducers1243723traduc_ers
trailers82912923trailers
trainers83114643trainers
trampers123210393trampers
trappers123711043trappers
trashers113013643trashers
trawlers113310203trawlers
treaders93311843treaders
treaters83615843treaters
trebuckets1891753trebuckets
trekker1034733trekker_
trenchers14288073trenchers
triceps11267343tric_eps
trices84826333tric_e_s
tricked144016163tricke_d
trickeries1647143trickeries
trickier143010233trickier_
trickles143013763trickles
tricks125319013trick__s
tricksters16264763tricksters
triers64321523tr__iers
triflers113110213triflers
triggers10257843triggers
trikes105419493tr_ike_s
trillers83613493trillers
trimers94615143tr_imers
trimmers12288913trimmers
trinkets1237143trinkets
trippers123210163trippers
trocars959043troc_ars
trochars1377853trochars
trochees132510183trochees
troches123715343troche_s
trocked144312243trocke_d
trocks123614633trock__s
troffers14125433troffers
trokes104019263tr_oke_s
trollers83211213trollers
troopers10289443troopers
trotters83310243trotters
troublers1135003troublers
trouncers1134803trouncers
troupers10359443troupers
trousers83910633trousers
trovers103713323tr_overs
trowsers11428003trowsers
truce75118693truc_e__
truced95312053truc_e_d
truceless11235393truceless
truck116115463truck___
truckage1543633truckage
truckages1643523truckages
truckful1743073truckful
truckfuls1842463truckfuls
trucking153310163trucking
truckings16235023truckings
truckle13358863truck_le
truckled15327313truckled
truckman1643153truckman
truckmen1643373truckmen
trudgens10255153trudgens
trudger9338733trudger_
trudges9339993trudge_s
trueness838693trueness
truer54916643tru__er_
trues54925323tru__e_s
truffes1356773truffe_s
trumpery1533613trumpery
trumpets12315573trumpets
trundlers10215003trundlers
trunked12358413trunke_d
trunks10429753trunk__s
trunnels844513trunnels
trusser74010263trusser_
trusses73813643trusse_s
trustees8339323trustees
truster73114313truster_
trustors8268913trustors
trysters11298373trysters
tubbers113411253t_ubbers
tubers85017033t_u_bers
tucked134017493t_ucke_d
tuckered1535963t_uckered
tucket124219483t_ucke_t
tucks114721123t_uck__s
tufters10298353t_ufters
tuggers93711443t_uggers
tuners64417343t_u_ners
turkeys1434523t_urkeys
turners73912893t_urners
turnkeys1542123turnkeys
turtlers8258203turtlers
tusker104212193t_usker_
tussers74313563t_ussers
tuyers94612563t_u_yers
unpuckers17243123unpuckers
vouchers16418623vouchers
whackers20326543whackers
whickers20297983whickers
wickers164114703_wickers
wreakers15328423wreakers
wrecker16367603wrecker_
younkers15295763younkers

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 Filter1786911461620.406440125.6
2DLD Change Limit1461623436.50022486.5
3Display Results3433430.1402450.0
 (SQL Overall)1786913437.04625360.6
 
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.