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

268 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
trekking123554(None) 
breaking153914252breaking
creaking153414122creaking
freaking163611452freaking
grokking1334812grokking
lekking11306502_lekking
recking144319922_recking
reeking123318642_reeking
streaking142010322streaking
streeking14217452streeking
tracking153715462tracking
traiking132511972traiking
treading103515332treading
treating92519612treating
trebling1139872trebling
treeing83414302tre_eing
trending103012832trending
tricking152714512tricking
troaking133310972troaking
trocking153612422trocking
troking123514102tr_oking
trucking153310162trucking
tweaking1635882tweaking
wreaking163010212wreaking
wrecking18328152wrecking
arcking145811963ar_cking
becking164416073_becking
beraking153612973beraking
braking143917713br_aking
breading123515463breading
breakings16297063breakings
breaming133612513breaming
breeding123411843breeding
breezing20368133breezing
brewing133411153bre_wing
bricking173911403bricking
brisking15329473brisking
broking143514823br_oking
brooking153710703brooking
checking20379203checking
cheeking18349083cheeking
cleeking15267813cleeking
clerking15257163clerking
cracking174013903cracking
cranking154613073cranking
creaming133413143creaming
creasing113314443creasing
creating113921953creating
creeling113513363creeling
creeping133310103creeping
creping122913653cre_ping
cresting114017043cresting
crewing133212633cre_wing
cricking173412653cricking
croaking153712163croaking
crocking174313443crocking
crooking153611343crooking
decking153915593_decking
dekeing13358353_dekeing
deking125614553_de_king
dreading113712803dreading
dreaming124011063dreaming
dredging12236423dredging
dreeing94311183dre_eing
dressing102810423dressing
drinking14308913drinking
drouking1436443drouking
eking106614983__e_king
erecting112415063erecting
erlking1236703er_lking
flecking18408233flecking
franking164310863franking
freckling1934703freckling
freeing113713913fre_eing
freezing21308323freezing
freshing152611023freshing
fretting122711523fretting
frisking16268363frisking
frocking18309573frocking
gecking154111363_gecking
gleeking14316493gleeking
greasing102811393greasing
greeing93613783gre_eing
greening103112533greening
greeting103112353greeting
greying124110893gre_ying
irking114611753ir__king
jerking19308923_jerking
kecking134111883_kecking
keeking114210893_keeking
leaking123616973_leaking
necking143913893_necking
peaking144317693_peaking
pecking164017783_pecking
peeking144414953_peeking
perking143716463_perking
phreaking1936473phreaking
pranking153813383pranking
prebaking1838063prebaking
preeing103817673pre_eing
preening113115843preening
prepping12309763prepping
pressing112516443pressing
prevuing1457253prevuing
preying133114553pre_ying
pricking173212603pricking
prinking153212453prinking
racking144323663_racking
raking114728423_r_aking
ranking124320883_ranking
reading93327213_reading
reaming103924013_reaming
reaping103621213_reaping
rearing83128783_rearing
reaving113820533_reaving
rebuking1536693_rebuking
redding103218513_redding
reding83825563_re_ding
redoing93516733_redoing
redwing122811983_redwing
reeding94124133_reeding
reefing114016863_reefing
reeling83126863_reeling
reeving113717663_reeving
reffing143712173_reffing
reining84425323_reining
reinking13311023_reinking
reiving113316843_reiving
rekeying1637563_rekeying
relying112914613_relying
remaking152613303_remaking
rending93924263_rending
renting84026853_renting
repping123314983_repping
resting85031183_resting
retaking133114283_retaking
retting83425883_retting
retying113213833_retying
reusing82516783_reusing
revoking1637803_revoking
revving14379343_revving
rewaking162310983_rewaking
ricking143920233_ricking
risking123914243_risking
rocking143619633_rocking
rooking123517363_rooking
rucking143216673_rucking
ryking14348113_r_yking
screaking16228243screaking
seeking124016063_seeking
sleeking133410963sleeking
smeeking15317833smeeking
smerking15258473smerking
sneaking133211093sneaking
speaking153212493speaking
specking17359733specking
steeking133411353steeking
streakings15235303streakings
streaming12239653streaming
streeling10189483streeling
stressing1038333stressing
strewing12289853stre_wing
striking133012233str_iking
stroking132610943str_oking
tacking144421483t_acking
tackling153211123tackling
taking114725953t__aking
talcking1567083talcking
talking123815823t_alking
tanking123918793t_anking
tasking124616323t_asking
teaming103917593t_eaming
tearing84021493t_earing
teasing83918513t_easing
tedding103210883t_edding
teeing73916973t_e_eing
teeming103513093t_eeming
teething1237163teething
tekkie934203t_ekki_e
tekkies1035943t_ekkies
telling83321083t_elling
temping122710693t_emping
tending94419163t_ending
tensing84616653t_ensing
tenting84621153t_enting
terming104016003t_erming
testing86021053t_esting
tewing103914823t_e_wing
thacking183110043thacking
thanking16409523thanking
theming133610473the_ming
thinking16289863thinking
threading14107593threading
threaping15106113threaping
threating131010053threating
threeping15104803threeping
threshing1645663threshing
thunking16196953thunking
ticking143218753t_icking
tickling15309433tickling
tieing73518763tie__ing
tiering8315253tie_ring
tinkling13239233tinkling
toeing74418473toe__ing
tokening1336463tokening
toking114420723t__oking
tracing103720153tr_acing
trackings16247543trackings
trading93517973tr_ading
trailing92916093trailing
training93015863training
tramming13279343tramming
tramping132711273tramping
trancing112812023trancing
trapping132911393trapping
trashing122613223trashing
trawling122710783trawling
treadling1137503treadling
treddling1234423treddling
trekked1134343trekk_ed
trekker1034733trekk_er
trekkers1133803trekkers
trembling1435193trembling
trenching15227653trenching
trepang10257293tre_pang
trephine1338933trephine
triaging102610543triaging
tricing103417353tr_icing
trickling1647723trickling
trifling122411503trifling
trigging11299583trigging
trilling92815963trilling
trimming13318653trimming
trining82919213tr_ining
tripling112712553tripling
tripping133210923tripping
trithing122811773trithing
trolling93212493trolling
tromping13319603tromping
trooping112710283trooping
trothing122410843trothing
trotting92510913trotting
trouping11249503trouping
trowing113413703tr_owing
trucing103211843tr_ucing
truckings16235023truckings
truckling1645073truckling
trudging11266443trudging
trueing83410183tr_ueing
truing73913933tr__uing
trumping13308733trumping
trussing9268653trussing
trusting93411653trusting
trying104214073tr__ying
trysting12267053trysting
tsking114210423t__sking
tucking143415183t_ucking
tusking124212063t_usking
tweeting12267033tweeting
tweezing21384113tweezing
wracking18349963wracking
wreckings19233683wreckings
wresting123811833wresting
wricking18349493wricking
yakking14376423_yakking
yerking15368813_yerking
yeuking15286123_yeuking
yukking14374733_yukking

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.423422437.4
2DLD Change Limit1461622687.46619577.0
3Display Results2682680.1102436.4
 (SQL Overall)1786912687.99922339.2
 
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.