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

180 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
backrest163939(None) 
backrests1744981backrests
backbeat1847842backbeat
backcast1887672backcast
backers153821882backers_
backless162910632backless
backlist16910652backlist
backmost1846632backmost
backrush1944102backrush
backseat1648902backseat
backset15314192backse_t
backsets1638852backsets
balkiest144112452balkiest
barest85327692ba__rest
barkiest144115152barkiest
blackest16269302black_est
bookrest1436492bookrest
tackiest143112432tackiest
wackest164710862wack_est
wackiest172610272wackiest
acerbest1245463_acerbest
achiest12315183_achiest
ackees124914583_ackees_
acquest1837173_acquest
acres76327763_ac_res_
actress948533_actress
acutest94410603_acutest
addrest958633_addrest
airest63825263_a_irest
armrest9310163_armrest
arrest63722633_a_rrest
babiest114414753ba_biest
baches135426943bac_hes_
backbeats1945763backbeats
backbend1944783backbend
backbit17129103back_bit
backcasts1985423backcasts
backchat2147113backchat
backcross1943923backcross
backdraft2154703backdraft
backdropt20124923backdropt
backed155725723back_e_d
backer144525523back_e_r
backfires2046173backfires_
backfit18108213back_fit
backfits19106953backfits
backhoes1938543backhoes_
backlash1945923backlash
backlists17117413backlists
backlit15911903back_lit
backout15612953back_out
backouts1698643backouts
backroom1846093backroom
backs135729623back__s_
backseats1746673backseats
backstreet1855033backstreet
backswept2243693backswept
backups1736173backups_
backwash2244943backwash
baddest112611143ba_ddest
baggiest123011753baggiest
bakers125323453ba_kers_
bakes117035373ba_k_es_
baldest102313533ba_ldest
balkers134915723balkers_
balmiest124110993balmiest
bankers133919093bankers_
bankrupt1643243bankrupt
bares75457133ba__res_
barghest1447913barghest
barguest1137163barguest
barkers134318513barkers_
barkless14318023barkless
barmiest125212783barmiest
barniest104815053barniest
barres84427543ba_rres_
barret84930483ba_rre_t
barrets94917103ba_rrets
basest84720493ba__sest
basket125722913bask_e_t
baskets135111833bask_ets
battiest104115553battiest
baulkiest1544233baulkiest
bawdiest14398673bawdiest
beachiest1638443beachiest
beakiest143313463beakiest
becket144619883beck_e_t
beckets15399823beck_ets
becrust1137983bec_rust
becurst1147853becur_st
bickers154316553bickers_
blacklist1746123blacklist
blackness1735663blackness
blankest14439063blank_est
blockiest1736363blockiest
bookrests1542623bookrests
boskiest14289733boskiest
bracket154117233brack_e_t
brackets163310433brack_ets
brakiest143912243brakiest
brickiest1737433brickiest
buckers153517453buckers_
bucket144620733buck_e_t
buckets153811693buck_ets
buckles153416093buckles_
buckoes153810393buckoes_
buckras1537343buckras_
bulkiest143511263bulkiest
cackles153717203cackles_
cakiest133215663ca_kiest
cockiest163013293cockiest
crest74632693__c_rest
dackers143417043dackers_
dankest122611673dank_est
darkest122512623dark_est
dickiest153412503dickiest
duckiest153211863duckiest
eagerest9510273eagerest
fairest10412293fa_irest
ficklest17267903ficklest
gawkiest16327313gawkiest
hackees165014103hackees_
hackers164619043hackers_
hackies163418243hackies_
hackles162917063hackles_
hackliest1836523hackliest
ickiest133611043_ickiest
jackers204214453jackers_
jacket194720673jack_e_t
jackets205011373jack_ets
jackies202912623jackies_
kickiest13319673kickiest
laciest93819033lac_iest
lackers134120543lackers_
lakiest113517263la_kiest
lankest112714113lank_est
lankiest122912493lankiest
larkiest123713313larkiest
luckiest143011443luckiest
mackles154415753mackles_
maturest1039693maturest
micklest16219123micklest
muckiest163210913muckiest
nacres85614453nac_res_
oakiest112913923oa_kiest
obscurest1343413obscurest
paciest112917803pac_iest
packers153818893packers_
packet144726503pack_e_t
packets155114773pack_ets
packness1636933packness
pawkiest17277883pawkiest
peckiest162711393peckiest
pickiest162712593pickiest
pockiest163412053pockiest
quackiest2435183quackiest
raciest92820013rac_iest
rackers134320453rackers_
racket125229423rack_e_t
rackets134916873rack_ets
rankest112713813rank_est
rarest65725483ra__rest
rockiest142912223rockiest
sackers133820223sackers_
sacrist9315423sac_rist
sarkiest123615063sarkiest
securest1058583securest
sickest131813793sick_est
slackest14289393slack_est
suckiest143314113suckiest
tackers134319623tackers_
tacket124627493tack_e_t
tackets134914363tack_ets
tackles133816523tackles_
tackless14419483tackless
talkiest123611223talkiest
wackes154717713wack_es_
whackiest2144983whackiest
yarest95018913ya__rest
yuckiest17328833yuckiest

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.420425454.8
2DLD Change Limit1461621807.06320694.0
3Display Results1801800.0802250.0
 (SQL Overall)1786911807.56323627.0
 
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.