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

189 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
trekkers113380(None) 
trekker1034731trekker_
breakers143810972breakers
reekers113613142_reekers
streakers13218132streakers
streekers13195802streekers
trackers143512852trackers
treaders93311842treaders
treaters83615842treaters
trekked1134342trekke_d
trickers143812812trickers
truckers14279012truckers
wreakers15328422wreakers
wreckers17315972wreckers
beakers134216873_beakers
breaker133912923breaker_
breeders11368893breeders
breviers1335923breviers
brewers123811063bre_wers
brokers133111913br_okers
checkers19317843checkers
chukkers1633483chukkers
crackers164111723crackers
creamers124111313creamers
creasers103612833creasers
creepers12318633creepers
croakers14288523croakers
deckers144413833_deckers
dreamers11369003dreamers
dredgers11256093dredgers
dressers9359863dressers
drinkers13277823drinkers
erecters102611613erecters
eskers105312223__eskers
frankers15348353frankers
freers94717303fre__ers
freezers20307173freezers
fretters113410303fretters
friskers15337373friskers
greasers93410253greasers
greeters92610113greeters
jerkers18287083_jerkers
kreuzers2132063kreuzers
leakers113415423_leakers
neckers134210463_neckers
peckers153312673_peckers
phreakers1834673phreakers
preavers13910263preavers
preeners102712813preeners
prefers123713333pre_fers
preggers12236833preggers
premiers122911653premiers
pressers103215023pressers
presters103419003presters
preyers124412363pre_yers
prickers163710673prickers
prinkers143010383prinkers
rackers134320453_rackers
rakers104123573_r_akers
rankers113217463_rankers
readers83823773_readers
reamers94221083_reamers
reapers93520453_reapers
rearers74323563_rearers
reavers108320743_reavers
rebukers14435683_rebukers
redders93615343_redders
reefers103312593_reefers
reeker103715593_reeker_
reelers73520273_reelers
refers93921083_re_fers
reivers105117083_reivers
rekeys13347693_re_keys
reliers75519213_reliers
remakers143811303_remakers
renders83821673_renders
renters74224813_renters
resters74130403_resters
retakers123511133_retakers
revers94529633_re_vers
revokers15366753_revokers
riskers114011993_riskers
rockers133916553_rockers
seekers113712333_seekers
shikkers14326523shikkers
sleekers12377993sleekers
sneakers12308643sneakers
speakers14299453speakers
streaker12229483streaker_
streamers11228073streamers
streeker12206643streeker_
strewers11409063stre_wers
strikers123611293str_ikers
strokers123910903str_okers
tackers134319623t_ackers
tacklers143010773tacklers
takers103923743t__akers
talkers113513213t_alkers
tankers113416913t_ankers
tearers75218233t_earers
teasers75317243t_easers
tedders94010233t_edders
teemers95012903t_eemers
teeners74415453t_eeners
teeters74018303t_eeters
teethers11328713teethers
tekkies1035943t_ekkies
telfers10299073t_elfers
tellers73717593t_ellers
tempers113513013t_empers
tenders83719723t_enders
tenners74014923t_enners
tenters73921103t_enters
termers95414503t_ermers
terriers84210823terriers
testers74124543t_esters
tethers103815313t_ethers
tetters74320473t_etters
thankers15297833thankers
theaters114211903theaters
thinkers15308703thinkers
threaders1365743threaders
threapers1444773threapers
threshers1545423threshers
tickers133617723t_ickers
ticklers14339303ticklers
tinkers113517143t_inkers
tinklers12298183tinklers
tokers104818893t__okers
tracers94917843tr_acers
tracker133515173tracker_
traders84316953tr_aders
trailers82912923trailers
trainers83114643trainers
trampers123210393trampers
trappers123711043trappers
trashers113013643trashers
trawlers113310203trawlers
treader84113833treader_
treadlers1045893treadlers
treater74219833treater_
trebles9311443treble_s
treeless839283treeless
treens65317873tre__ens
trees55835763tre__e_s
trekking1235543trekking
treks96016853tre_k__s
tremblers1334483tremblers
tremors93711233tre_mors
trenchers14288073trenchers
tressels8367653tressels
tresses73719543tresse_s
trevets10499973tre_vets
tricker134615523tricker_
trickery17297343trickery
triers64321523tr__iers
triflers113110213triflers
triggers10257843triggers
trikes105419493tr_ike_s
trillers83613493trillers
trimers94615143tr_imers
trimmers12288913trimmers
trinkets1237143trinkets
trippers123210163trippers
troffers14125433troffers
trokes104019263tr_oke_s
trollers83211213trollers
troopers10289443troopers
trotters83310243trotters
troupers10359443troupers
trousers83910633trousers
trovers103713323tr_overs
trowsers11428003trowsers
trucker134010733trucker_
trucklers15295583trucklers
trudgers10256863trudgers
trussers8348283trussers
trusters83112263trusters
trysters11298373trysters
tuckers134014353t_uckers
tuskers113710043t_uskers
tweeners11306243tweeners
tweeters11287143tweeters
tweezers20254383tweezers
ureters7311823ure_ters
wreaker143610043wreaker_
wrecker16367603wrecker_
wresters112711733wresters
yakkers13304273_yakkers

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 Limit1461621896.93621073.0
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.42224075.9
 
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.