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 “brent” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

130 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
brent7573413(None) 
bent67759911b_ent
blent76230951blent
brant74742171brant
bren65629561bren_
brens75823361brens
brents84717271brents
brunt75728751brunt
rent46661241_rent
absent84016992absent
agent65829642agent
ament76036542ament
anent54931842anent
ardent73022612ardent
arena55323812arena
arene55329412arene
argent74023662argent
arpent84822092arpent
barest85327692barest
beat66168302b_eat
been65335782been_
beet66457542b_eet
belt65754032b_elt
ben56554922b_en_
bend76435262b_end
bene66439492b_ene
bens65945702b_ens
bento75922952b_ento
bents76033692b_ents
bereft114317302bereft
beret74946362beret
best66355322b_est
bet58376672b_e_t
bint67355032b_int
biont7727162biont
bleat75737002bleat
blend85317452blend
blest76431722blest
blet66247672ble_t
blunt75525022blunt
bract96332722bract
bran65740382bran_
brand85124492brand
brank115222282brank
brans75437432brans
brants85723052brants
brat66055542br_at
bread85523112bread
break115319402break
bream95121812bream
breast8319632breast
breath113916262breath
bred75130972bre_d
brede85520502brede
bree67241262bre_e
breed85526692breed
brees75632552brees
breve105317052breve
brevet115717332brevet
brew95023562bre_w
brews105617072brews
brin67038192brin_
brine75132272brine
bring85528502bring
brink116122002brink
brins75533972brins
briny104719662briny
brit66350152br_it
britt75732232britt
bronc91714342bronc
bruit76126722bruit
brunet84419292brunet
brung84613912brung
brunts85215452brunts
brut66537962br_ut
bunt65850852b_unt
buret77444012bure_t
burnet84326172burnet
burnt75230322burnt
cent67451012_cent
crept95125892crept
crest74632692crest
dent57158412_dent
drest65530342drest
erect74129332erect
event85924442event
frena85915272frena
fret75845042fre_t
front85029222front
gent56954392_gent
gerent73223092gerent
grant64840022grant
great66034242great
greet65835322greet
grunt65523542grunt
hent76656382_hent
kent86846962_kent
lent46360532_lent
orient6322532orient
parent83230422parent
pent66559072_pent
prest75736352prest
print74837462print
rant45864672_rant
reft75141272_reft
rend56136572_rend
rente54733782_rente
rents55935182_rents
rerent63832452rerent
rest46459842_rest
ret35982832_re_t
runt46647982_runt
scent75831622scent
sent46963012_sent
shent85933492shent
spent75532832spent
sprent84522382sprent
stent55634512stent
subrent9315082subrent
tent46159862_tent
treat56240352treat
trend64817452trend
tret46653532tre_t
unrent63219782unrent
urgent73816042urgent
vent76049052_vent
went76051872_went
wren78221682wren_
wrens85016242wrens
wrest84925432wrest

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538001301.87328724.0
3Display Results1301300.0333939.4
 (SQL Overall)1786911301.99989390.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.