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

183 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
barre7592954(None) 
barbe95328281barbe
barde85330771barde
bare65460521ba_re
barer74535801barer
barge85631021barge
barred95725791barred
barrel84517871barrel
barren85317611barren
barres84427541barres
barret84930481barret
barye105021491barye
tarre55825631tarre
acre67330772_acre
are37874572_a_re
arse46539272_arse
babe86835822ba_be
bade75140882ba_de
badge94819682badge
bairn77515532bairn
baize164717392baize
bake105637512ba_ke
baker115629542baker
bale66353842ba_le
baler75635272baler
bane65250422ba_ne
bar58070552ba_r_
barb85240062ba_rb
barbed115121312barbed
barbel104317072barbel
barber104419322barber
barbes104526232barbes
barbet104427882barbet
barbie105018352barbie
barbs95928192barbs
barca91319432barca
bard75648862ba_rd
barded105426422barded
bardes95026932bardes
bards87139642bards
bared85144482bared
barege94713542barege
bares75457132bares
barf95844412ba_rf
barfed125416382barfed
barfs104826002barfs
barged105822642barged
bargee94624442bargee
barges94528252barges
baric96125692baric
barite84224812barite
bark106242152ba_rk
barked135027312barked
barker124822862barker
barks115735812barks
barky145721612barky
barley115116762barley
barm86739602ba_rm
barmen105418532barmen
barmie103816392barmie
barms96128462barms
barmy125218762barmy
barn66444642ba_rn
barned95623582barned
barney115314452barney
barns76335142barns
barny105821732barny
baron78131242baron
barque17239552barque
barrage10710842barrage
barrels94514362barrels
barrens94414322barrens
barrets94917102barrets
barrier94017732barrier
barrio8312572barrio
barrow114512762barrow
bars66564092ba_rs
barter85525372barter
barware12610702barware
baryes116218502baryes
baryte115312882baryte
base64847022ba_se
baser74828922baser
baste74829982baste
bate66552422ba_te
bathe105822882bathe
bearer85323912bearer
berme96022942berme
berry104521772berry
birle75023632birle
birr66022362birr_
birred94713202birred
birrs74917102birrs
birse74517402birse
bizarre1844102bizarre
blare75826232blare
bore66051332b_ore
borer75131272borer
borne77926792borne
brace95629272brace
brae65639112b_rae
brake116025342brake
brave104925502brave
braze165423452braze
bree67241262b_ree
brie65837902b_rie
brr56921922b_rr_
brrr65312292b_rrr
burke115122762burke
burr65631232burr_
burred95820722burred
burrer83718472burrer
burro75018492burro
burrs74925652burrs
burry105221562burry
burse75527252burse
byre95023852b_yre
cadre85419012cadre
care66968372ca_re
carer74942332carer
carle74535702carle
carr65434702carr_
carrel84718632carrel
carrs75730852carrs
carry105823782carry
carse74934332carse
carte75940422carte
carve106227752carve
dare55848862da_re
darer65230792darer
eagre64315322eagre
farce104925322farce
fare76354462fa_re
farer86733142farer
farle86929242farle
garred85217402garred
garret74426552garret
hare76255732ha_re
harry115322952harry
jarred144613252jarred
laree56036292laree
large65325462large
madre85720172madre
mare64759322ma_re
marge85328332marge
marred95421042marred
marrer83716672marrer
marry104821692marry
marse76231152marse
murre74821072murre
nacre75715362nacre
padre86018162padre
parae76335702parae
pare66760842pa_re
parer75839902parer
parge85831852parge
parle75836162parle
parr65731152parr_
parred95024072parred
parrel84515982parrel
parrs75928672parrs
parry105323752parry
parse75236992parse
parure8312522parure
parve109824852parve
rare45348432ra_re
rarer54731702rarer
sabre74821502sabre
saree55044662saree
sarge65531132sarge
tare45957622ta_re
targe65227092targe
tarred74720282tarred
tarres64723042tarres
tarry85422512tarry
urare56322552urare
varve115716852varve
ware76254722wa_re
warred104019842warred
warren95012852warren
yare75636942ya_re
yarer84321572yarer
zaire14311992zaire

Search took 7 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.280638182.1
2DLD Change Limit538001835.7969282.3
3Display Results1831830.1731057.8
 (SQL Overall)1786911836.24928595.1
 
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.