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 “bridals” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

263 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
bridals103862(None) 
bridal9511451bridal_
bradawls1443672bradawls
briars84814822bri_ars
bridally1446452bridally
brides94423512brid_es
bridges113911332bridges
bridle94115462brid_le
bridles104114472bridles
brills84916292bri_lls
bromals1139742bromals
burials93612082buri_als
rials55026672_ri_als
rivals94213182_rivals
riyals94111082_riyals
trials64319882tri_als
tribals9610752tribals
urials64415192uri_als
urinals7610262urinals
abridges1245303abridges
aerials74017553aeri_als
alidads936293alidads
amidols10457563amidols
animals94111703animals
apicals1159923apicals
argals75517713ar_gals
arias55438023ari_a_s
aridly105513703arid_ly
ariels65119373ari_els
arils58732203ari__ls
arrivals1145943arrivals
baals76122703b__aals
badass949293b_adass
bails75933523bai__ls
baizas173810823baiza_s
bals66354043b___als
bandas95120543banda_s
barbitals1345263barbitals
barillas10310193barillas
bedels94015273b_edels
beldams1237053beldams
bendays13327513bendays
bharals1236733bharals
biali73419073b_i_ali
bialis83617163b_i_alis
bialy105119323b_i_aly
bialys11387913b_i_alys
bias64738163b_i_a_s
biders94822803b_iders
bides85536773b_id_es
bidets95215533b_idets
bidis86721143b_id_is
bids75838453b_id__s
bills75632863b_i_lls
bimahs13508303b_imahs
bimas95521743b_ima_s
binal75323823b_inal_
birdcall1343693birdcall
birdcalls1443393birdcalls
birders103913263birders
birdies104016213birdies
birds85421333bird__s
birls74023163b_i_rls
boils75427193boi__ls
borals86721913b_orals
bordels103911973bordels
borides10515153borid_es
borstals1037463borstals
bradawl1344363bradawl
brads85528293br__ads
braes75735053br__aes
brags85625103br__ags
braiders114110573braiders
braids95015693braid__s
brails84621293br_ails
brans75437433br__ans
bras65746453br__a_s
brasils9410973brasils
brass75428023br__ass
brats75336013br__ats
bravas114913323brava_s
brawls115214333br_awls
braws106425193br__aws
brays106723113br__ays
brazas175812433braza_s
brazils1867753brazils
breads95419203br_eads
breaks124816423br_eaks
breams104815043br_eams
bredes94818473bred_es
briar75718153bri_a_r
briard94311293bri_ard
briards10398553briards
briary114912003bri_ary
bribable1137223bribable
bribees11409283bribees
bribers114111503bribers
bribes105918533bri_bes
brickle15279933brickle
brickles162810283brickles
bricks144614623bri_cks
bricole112810493bricole
bricoles122610303bricoles
bride86425533brid__e
bridge103711883brid_ge
bridged12339033bridged
bridled113611143bridled
bridler103811073bridler
bridlers11359183bridlers
bridoon1046203bridoon
bridoons1145423bridoons
briefly1534573briefly
briefs115510073bri_efs
briers85319733bri_ers
bries74942153bri__es
brigade1136493brigade
brigades1236393brigades
brigand1136643brigand
brigands1245623brigands
brights133710233brights
brigs85823223bri__gs
brill74819953bri__ll
brillo84211003bri_llo
brillos9369183brillos
brims94721623bri__ms
brindle104210103brindle
brindles113710223brindles
briners94315633briners
brines85028853bri_nes
brings94618433bri_ngs
brinies93317913brinies
brinks124616313bri_nks
brins75533973bri__ns
brios74725723bri__os
bris65539613bri___s
brisant9312683brisant
brises84927613bri_ses
briskly16165403briskly
brisks124611403bri_sks
briss75824273bri__ss
brisses94314313brisses
bristle91910103bristle
bristles101510433bristles
bristly12178063bristly
bristols1046773bristols
briths115113863bri_ths
brits76433083bri__ts
brittle9168603brittle
brittles10178653brittles
brittly12165973brittly
britts84813443bri_tts
broadly1337153broadly
broads94515153br_oads
brogans1049663brogans
broiders114211193broiders
broils84114173br_oils
bromal10313653bromal_
brumal1049503brumal_
brutal859383brutal_
bubals103513843b_ubals
burial84117623buri_al_
buttals938503buttals
cordials1139633cordials
craals84113303cr_aals
credal9311673credal_
dals57145123___dals
dials64925343_di_als
dreidels1033213dreidels
dreidls934053dreid_ls
drills74414203dri_lls
drivels11397923drivels
ericas8315463erica_s
finals94316163_finals
forbidals1543493forbidals
friars93812093fri_ars
fridges12369483fridges
frills94414223fri_lls
frivols1334743frivols
graals74112913gr_aals
graduals1046203graduals
griddle1035503griddle
griddles1145753griddles
grides84422363grid_es
grids75321393grid__s
grills74314803gri_lls
ideals75012503__ideals
idols65514133__idols
idyls9498803__idyls
irides74519123irid_es
irids66417773irid__s
kraals10378433kr_aals
krills104211283kri_lls
lidars7310783_lidars
medals94218053_medals
medials103914733medials
modals93914453_modals
nidal65217103_nidal_
orals55826483or__als
orbitals1045713orbitals
ordeals877993ordeals
ordinals946763ordinals
oriels64914623ori_els
origans839973origans
ovoidals1242493ovoidals
pedals94316033_pedals
phials1158873phi_als
pibals103813083_pibals
pipals104213643_pipals
prides94324183prid_es
prills84015613pri_lls
primal104014623primal_
primas104418103prima_s
radars71314673_radars
radials83614643_radials
ratals64219583_ratals
reals55038653_r_eals
redans75421023_redans
redials84416883_redials
rial45938093_ri_al_
rias45540593_ri_a_s
ribald9209293_ribald
ribalds10236673_ribalds
ridable101412493_ridable
riddle83915713_riddle
riddles93215023_riddles
riders74123903_riders
rides66140813_rid_es
ridgels9348023_ridgels
ridges85817013_ridges
ridgils9326573_ridgils
rids56539553_rid__s
riels55121333_ri_els
rills55032713_ri_lls
rituals738353_rituals
rival85216503_rival_
riyal84413433_riyal_
royals93711263_royals
sandals82715203sandals
seidels838393seidels
sendals81912263sendals
serials73919743seri_als
sials54227243_si_als
sirdars8228213sirdars
sisals63013573_sisals
spinals93911863spinals
spirals93212513spirals
spitals93011593spitals
ticals83214713_ticals
tidal64516443_tidal_
triacs83913223tri_acs
triads74513533tri_ads
trial54926353tri_al_
tribal8611133tribal_
trills64319853tri_lls
trinal6516963trinal_
triols66117803tri_ols
urial54823023uri_al_
urinal6614123urinal_
vandals113211663vandals
vials85822383_vi_als
vinals94716483_vinals
vitals94514303_vitals
whidahs1743333whidahs

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272636.98619185.1
3Display Results2632630.0932828.0
 (SQL Overall)1786912637.48523873.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.