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

206 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
bride8642553(None) 
bide76041471b_ide
boride9415901boride
brede85520501brede
bribe94820771bribe
brides94423511brides
bridge103711881bridge
bridle94115461bridle
brie65837901bri_e
brine75132271brine
gride75223581gride
pride84724731pride
ride55945121_ride
abide86223702abide
abrade9313052abrade
abridge1135692abridge
aide56044992_aide
amide86128472amide
arid57642712arid_
arider74717742arider
arise56436432arise
aside65122082aside
azide155617162azide
bade75140882b_ade
baize164717392baize
barde85330772barde
barite84224812barite
beige81515372beige
berime105317332berime
beside95114612beside
betide95115972betide
bice86235552b_ice
bid67751782b_id_
bided95424962b_ided
bider85728372b_ider
bides85536772b_ides
bidet84935622b_idet
bidi78226562b_idi
bids75838422b_ids
bike106532592b_ike
bile66147172b_ile
bine66650852b_ine
bird76128312bird_
birded104414302birded
birder94915492birder
birdie94013782birdie
birds85421332birds
birle75023632birle
birse74517402birse
bise66437092b_ise
bite66546992b_ite
bize155926282b_ize
blade85923332blade
blite76225352blite
bode75838752b_ode
boite74426322boite
bolide9515562bolide
borides10515152borides
brace95629272brace
brad75234342brad_
brads85528292brads
brae65639112br_ae
braid85822262braid_
braided114013212braided
braider105112992braider
braids95015682braids
braise84318752braise
braize174113112braize
brake116025342brake
brave104925502brave
braze165423452braze
bred75130972bred_
bredes94818472bredes
bree67241262br_ee
breed85526692breed
breve105317052breve
briar75718152briar
bribed115312842bribed
bribee104316362bribee
briber104714042briber
bribes105918532bribes
brick134618152brick
bridal9511452bridal
bridged12339032bridged
bridges113911332bridges
bridled113611142bridled
bridler103811072bridler
bridles104114472bridles
brief105422592brief
brier74527402brier
bries74942152bries
brig76528032bri_g
brigade1136492brigade
brigs85823222brigs
brill74819952brill
brim85629372bri_m
brims94721622brims
brin67038192bri_n
brinded115112052brinded
brindle104210102brindle
brined95118412brined
briner84519042briner
brines85028852brines
bring85528502bring
brink116122002brink
brins75533972brins
briny104719662briny
brio65432492bri_o
brios74725722brios
bris65539612bri_s
brises84927612brises
brisk115615982brisk
briss75824272briss
brit66350152bri_t
brith104924372brith
brits76433082brits
britt75732232britt
broider103912972broider
broke116019782broke
brome94421972brome
bromide12269582bromide
brose75227032brose
bruise83412872bruise
brume95817982brume
brute75321782brute
burdie93615022burdie
buried94822372buried
chide115321012chide
cried84624282cried
crime94822692crime
cripe95521142cripe
crude86018572crude
debride1138592debride
deride84420032deride
dried75321382dried
drive95318002drive
eide55832232_eide
elide64922642elide
erode64520992erode
fridge11379252fridge
fried95322912fried
frise85322452frise
glide74521592glide
grade75126092grade
grid65829612grid_
grided95117042grided
grides84422362grides
grids75321392grids
grime85021322grime
gripe84622962gripe
guide75019882guide
hide85134622_hide
imide85716872imide
irade65618152irade
irid55927162irid_
irides74519122irides
irids66417762irids
nide55535782_nide
oreide7311672oreide
oroide7311702oroide
oxide131210952oxide
price93725412price
prided103618032prided
prides94324182prides
pried84426862pried
prime96525602prime
prise74632612prise
prize164718942prize
prude84615972prude
rede55037662_rede
rice64942912_rice
rid46754622_rid_
rider65231302_rider
rides66140812_rides
ridge75018662_ridge
rids56539542_rids
rife74632322_rife
rile45650532_rile
rime65138882_rime
ripe66038922_ripe
rise45945232_rise
rite45849452_rite
rive75537722_rive
rode55844302_rode
rude55632782_rude
side55444482_side
slide64725412slide
snide64318722snide
stride75420962stride
tide55237372_tide
trade65026042trade
tribe74420262tribe
trice75127492trice
tried65026912tried
trike95320162trike
trine54734602trine
triode75311892triode
tripe75425382tripe
trite54730032trite
trode65322852trode
ureide7310362ureide
urine55026592urine
vide85432752_vide
wide85235402_wide
wried95518562wried
write85522832write

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.0961861364.6
2DLD Change Limit538002061.93627789.3
3Display Results2062060.0464478.3
 (SQL Overall)1786912062.07885991.8
 
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.