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

139 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
barye10502149(None) 
barbe95328281barbe
barde85330771barde
bare65460521bar_e
barge85631021barge
barre75929541barre
baryes116218501baryes
baryte115312881baryte
abye97921002_abye
are37874572_ar_e
arse46539272_arse
aryl75922342_aryl
aye67151762_a_ye
babe86835822ba_be
baby116723682baby_
bade75140882ba_de
badge94819692badge
baize164717392baize
bake105637512ba_ke
bale66353842ba_le
bane65250432ba_ne
bar58070552bar__
barb85240062bar_b
barbed115121312barbed
barbel104317072barbel
barber104419322barber
barbes104526232barbes
barbet104427882barbet
barbie105018352barbie
barbs95928192barbs
barca91319432barca
bard75648862bar_d
barded105426422barded
bardes95026932bardes
bards87139642bards
bared85144482bared
barege94713542barege
barer74535802barer
bares75457132bares
barf95844412bar_f
barfed125416382barfed
barfs104826002barfs
barged105822642barged
bargee94624442bargee
barges94528252barges
baric96125692baric
barite84224812barite
bark106242152bar_k
barked135027312barked
barker124822862barker
barks115735812barks
barky145721612barky
barley115116762barley
barm86739602bar_m
barmen105418532barmen
barmie103816392barmie
barms96128462barms
barmy125218762barmy
barn66444642bar_n
barned95623582barned
barney115314452barney
barns76335142barns
barny105821732barny
baron78131242baron
barque17239552barque
barred95725792barred
barrel84517872barrel
barren85317612barren
barres84427542barres
barret84930482barret
bars66564092bar_s
barter85525372barter
baryon111211612baryon
baryta114310292baryta
barytes124611152barytes
base64847022ba_se
baste74829982baste
bate66552422ba_te
bathe105822882bathe
bay89661642ba_y_
bayed115423022ba_yed
bays97143912ba_ys
berme96022942berme
beryl101211672beryl
birle75023632birle
birse74517402birse
blare75826232blar_e
bore66051332bor_e
borne77926792borne
brace95629272brace
brae65639112b_rae
brake116025342brake
brave104925502brave
bray95232902bray_
brayed124615782brayed
brayer115315312brayer
brays106723112brays
braze165423452braze
bree67241262b_ree
brie65837902b_rie
burke115122762burke
burse75527252burse
bury95633592bury_
bye86134592b__ye
byre95023852byr_e
care66968372car_e
carle74535702carle
carse74934332carse
carte75940422carte
carve106227752carve
dare55848862dar_e
farce104925322farce
fare76354462far_e
farle86929242farle
hare76255732har_e
laree56036292laree
large65325462large
mare64759332mar_e
marge85328332marge
marse76231152marse
nary76931222nary_
parae76335702parae
pare66760842par_e
parge85831852parge
parle75836162parle
parse75236992parse
parve109824852parve
rare45348432rar_e
rye66032542__rye
saree55044662saree
sarge65531132sarge
tare45957622tar_e
targe65227102targe
tarre55825632tarre
varve115716852varve
vary105226062vary_
ware76254722war_e
wary106740012wary_
yare75636942yar_e

Search took 2 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.313570897.8
2DLD Change Limit538001391.62333148.5
3Display Results1391390.0334212.1
 (SQL Overall)1786911391.96990752.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.