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

250 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
barde8533077(None) 
bade75140881ba_de
barbe95328281barbe
bard75648861bard_
barded105426421barded
bardes95026931bardes
bards87139641bards
bare65460521bar_e
bared85144481bared
barge85631021barge
barre75929541barre
barye105021491barye
abide86223702abide
abode85518812abode
abrade9313052abrade
aide56044992_aide
ardeb8314522_ardeb
are37874572_ar_e
arse46539272_arse
baaed85218162baaed
babe86835812ba_be
bad67763152ba_d_
badder103817512badder
baddie104114032baddie
baddy125016022baddy
badge94819682badge
bads77048862ba_ds
baize164717392baize
bake105637512ba_ke
baked126130772baked
bald76432902bald_
balded105417512balded
balder95318862balder
balds85524642balds
baldy115518932baldy
bale66353842ba_le
baled85436442baled
band76740902band_
banda85223102banda
banded105223172banded
bander93928222bander
bands85233422bands
bandy114824182bandy
bane65250422ba_ne
baned85436352baned
bar58070552bar__
barb85240062bar_b
barbed115121312barbed
barbel104317072barbel
barber104419322barber
barbes104526232barbes
barbet104427882barbet
barbie105018352barbie
barbs95928192barbs
barca91319432barca
bardic11312922bardic
barege94713542barege
barer74535802barer
bares75457132bares
barf95844402bar_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
baryes116218502baryes
baryte115312882baryte
base64847022ba_se
based85331582based
baste74829982baste
bate66552422ba_te
bated85935532bated
bathe105822882bathe
baud74928422baud_
bauds85821042bauds
bawd105520842bawd_
bawds116115492bawds
bawdy147513282bawdy
bayed115423022bayed
beard86024962beard_
bearded114212132bearded
beards94116672beards
berme96022942berme
bide76041472b_ide
bird76128312bird_
birded104414302birded
birder94915492birder
birdie94013782birdie
birds85421332birds
birle75023632birle
birse74517402birse
blade85923332blade
blare75826232blar_e
blared95018242blared
board85523002board_
boarded113910502boarded
boarder103910322boarder
boards94616932boards
bode75838752b_ode
bordel94514572bordel
border94419972border
bore66051332bor_e
bored85034302bored
boride9415902boride
borne77926792borne
brace95629272brace
brad75234342brad_
brads85528292brads
brae65639112b_rae
brake116025342brake
brave104925502brave
braze165423452braze
bred75130972b_red
brede85520502brede
bree67241262b_ree
bride86425532bride
brie65837902b_rie
burd75534262burd_
burden9412472burden
burdie93615022burdie
burds84626062burds
burke115122762burke
burse75527252burse
byre95023852byr_e
cade76443912ca_de
cadre85419012cadre
card710245872card_
carded105424902carded
carder94524182carder
cards85137932cards
care66968372car_e
cared86050092cared
carle74535702carle
carse74934332carse
carte75940422carte
carve106227752carve
dare55848862dar_e
dared75935012dared
eared65139502eared
fade85736342fa_de
farce104925322farce
fard85639062fard_
farded114518952farded
fardel104712592fardel
fards96629842fards
fare76354462far_e
fared95842342fared
farle86929242farle
garda7316762garda
garden84215082garden
grade75126092grade
hade85440192ha_de
hard85443502hard_
harden105718532harden
harder105022402harder
hards96435652hards
hardy125622062hardy
hare76255732har_e
hared95742182hared
horde94623052horde
irade65618152irade
jade125325442ja_de
lade56345982la_de
lard56742002lard_
larded84319092larded
larder73720972larder
lards65331862lards
lardy96119272lardy
laree56036292laree
large65325462large
made75440232ma_de
madre85720172madre
mare64759322mar_e
marge85328332marge
marse76231152marse
merde84320122merde
nard56634452nard_
nards65928462nards
oared65030652oared
padre86018162padre
parade94720642parade
parae76335702parae
pard76441322pard_
pardee93922022pardee
pardi85723952pardi
pardie96021442pardie
pards85634332pards
pardy115523952pardy
pare66760842par_e
pared86946762pared
parge85831852parge
parle75836162parle
parse75236992parse
parve109824852parve
rare45348432rar_e
rared65738322rared
sade55544472sa_de
sard55344242sard_
sards64736182sards
saree55044662saree
sarge65531132sarge
sarode75317512sarode
tardo65321102tardo
tardy94720462tardy
tare45957622tar_e
tared69340052tared
targe65227092targe
tarre55825632tarre
trade65026042trade
varve115716852varve
wade85237062wa_de
ward86542252ward_
warded115021042warded
warden104515512warden
warder104020272warder
wards97734402wards
ware76254722war_e
wared96339872wared
yard85633252yard_
yarded114714022yarded
yarder103813972yarder
yards95324612yards
yare75636942yar_e

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 Limit538002501.79629955.5
3Display Results2502500.0633968.3
 (SQL Overall)1786912501.95291542.5
 
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.