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

143 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
baryes11621850(None) 
barbes104526231barbes
bardes95026931bardes
bares75457131bar_es
barges94528251barges
barres84427541barres
barye105021491barye_
barytes124611151barytes
abyes105518532_abyes
ares45871022_ar_es
arles56735742_arles
arses55733872_arses
aryls87015812_aryls
ayes76543512_a_yes
baases85218012baases
babes95834112ba_bes
babies106123642babies
baches135426942baches
badges103917362badges
baizes174315052baizes
bakes117035372ba_kes
bales76250082ba_les
banes74945582ba_nes
barbe95328282barbe_
barbed115121312barbed
barbel104317072barbel
barbels114514432barbels
barber104419322barber
barbers114317502barbers
barbet104427882barbet
barbets114915842barbets
barbies114519592barbies
barbs95928192bar_bs
barcas101016602barcas
barde85330772barde_
barded105426422barded
bards87139642bar_ds
bare65460522bar_e_
bared85144482bar_ed
bareges105212032bareges
barer74535802bar_er
barest85327692bar_est
barfed125416382barfed
barfs104826002bar_fs
barge85631022barge_
barged105822642barged
bargee94624442bargee
bargees105415872bargees
barites94322332barites
barked135027312barked
barker124822862barker
barkers134318512barkers
barks115735812bar_ks
barless94317002barless
barley115116762barley
barleys125011842barleys
barmen105418532barmen
barms96128462bar_ms
barned95623582barned
barney115314452barney
barneys12569562barneys
barns76335142bar_ns
barons85025382barons
barques18259642barques
barre75929542barre_
barred95725792barred
barrel84517872barrel
barrels94514362barrels
barren85317612barren
barrens94414322barrens
barret84930482barret
barrets94917102barrets
bars66564092bar__s
barter85525372barter
barters94223032barters
baryon111211612baryon
baryons121010472baryons
baryta114310292baryta
barytas12378282barytas
baryte115312882baryte
bases75644352ba_ses
bashes115631392bashes
basses85428302basses
bastes85330382bastes
bates75846342ba_tes
bathes116524832bathes
bayed115423022ba_yed
bays97143912ba_y_s
bermes106023002bermes
beryls11107882beryls
birles84920642birles
birses84717732birses
blares85021632blar_es
bores76448252bor_es
braces108427772braces
braes75735052b_raes
brakes124923122brakes
braves115524082braves
brayed124615782brayed
brayer115315312brayer
brayers124511902brayers
brays106723112bray_s
brazes175522192brazes
brees75632552b_rees
bries74942152b_ries
buries84633272buries
burkes124421312burkes
burses84425512burses
byes95230532b__yes
byres104421382byr_es
cares77369182car_es
caries85147622caries
carles85435082carles
carses85233652carses
cartes86239472cartes
carves115128452carves
dares66146702dar_es
farces115223322farces
fares85852872far_es
farles96025782farles
hares86255542har_es
larees65323112larees
lares54852632lar_es
larges74824232larges
mares76457632mar_es
marges94525712marges
marses84827112marses
nares55544152nar_es
pares77164482par_es
parges94529542parges
paries84742512paries
parles86334392parles
parses85534702parses
rares55247442rar_es
ryes75529352__ryes
sarees65329942sarees
sarges75128592sarges
tares57456562tar_es
targes74524592targes
tarres64723042tarres
varies94330872varies
varves124414782varves
wares88250582war_es

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 Filter178691825510.1101624463.6
2DLD Change Limit825511432.79629524.7
3Display Results1431430.0502860.0
 (SQL Overall)1786911432.95660450.3
 
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.