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

153 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
brigade113649(None) 
brigaded1344571brigaded
brigades1236391brigades
bride86425532bri__de
brigadier1343322brigadier
brigand1136642brigand
brigands1245622brigands
brocade1238532brocade
frigate11311062frigate
tribade1037292tribade
abrade9313053abr__ade
abrogate11129603abrogate
alidade936993alidade
arcade91013643ar_cade
bade75140883b___ade
baggage1235633baggage
ballade104012563ballade
barricade1454523barricade
begaze1838333b_egaze
beige81515383beig__e
beigne9148613beig_ne
bide76041503b_i__de
biface1358103b_iface
bigamy1436343b_igamy
bigarade1244763b_igarade
bigeye1236643b_igeye
biggie103810933b_iggie
binate8419773b_inate
blade85923333b__lade
boride9415903bori__de
brace95629273br__ace
brad75234343br__ad_
brads85528293br__ads
brae65639113br__a_e
bragged12449843bragged
brake116025343br__ake
bravado1343603bravado
brave104925503br__ave
braze165423453br__aze
bread85523113br_ead_
breaded115014063br_eaded
breads95419203br_eads
bready124511183br_eady
brede85520503br__ede
bregmate1345533bregmate
brewage1347183brewage
briar75718153bri_a_r
briard94311293bri_ard
briards10398553briards
briars84814823bri_ars
briary114912003bri_ary
bribable1137223bribable
bribe94820783bri__be
bribed115312843bribed_
bribee104316363bri_bee
bricked164312063bricked
brickle15279933brickle
bricole112810493bricole
bridal9511453brida_l
bridals1038623bridals
brides94423513bri__des
bridge103711883bri_dge
bridged12339033bridged_
bridle94115463bri_dle
bridled113611143bridled
brie65837903bri___e
briefed1335743briefed
brig76528033brig___
brigadiers1442153brigadiers
brigading1445143brigading
brigandage1551353brigandage
brigandine1452753brigandine
bright124215923brig_ht
brighten1466243brighten
brighter1476663brighter
brights133710233brights
brigs85823223brig__s
brimmed14386783brimmed
brinded115112053bri_nded
brindle104210103brindle
brine75132273bri__ne
brined95118413brined_
brioche14275923brioche
brisance1245953brisance
brisant9312683brisant
brisked144210003brisked
bristle91910103bristle
brittle9168603brittle
broad84817693br_oad_
broaden10289143br_oaden
broader103412613br_oader
broads94515153br_oads
brocaded1436353brocaded
brocades1358713brocades
brogan9311043broga_n
brogans1049663brogans
brogue94211033brog_ue
brokage1436673brokage
bromate11313553bromate
bromide12269583bromide
burgage1136633burgage
crusade1036053crusade
ergate7315143er_gate
frigates12310933frigates
frigged13439053frigged
frigid1136923frigid_
grade75126093gr__ade
grenade938413grenade
gride75223583gri__de
grillade1085143grillade
grimace1255083grimace
irade65618153__irade
irrigate967633irrigate
ligase7259913_ligase
ligate72519253_ligate
marinade11259383marinade
obligate11198303obligate
origami1045453origami
origan7310693origa_n
origans839973origans
prebade12310283prebade
prefade1339013prefade
pregame1239553pregame
premade12311443premade
pride84724733pri__de
prigged12398933prigged
primage12169143primage
primate111516283primate
private121513263private
prograde1247183prograde
regale74821453_regale
regave104713383_regave
regrade92612033_regrade
remade94316983_remade
ride55945133_ri__de
rigged94517403_rigged
rigid7913893_rigid_
rivage1038843_rivage
rugae65114763_ruga_e
rugate75813813_rugate
tirade7311693_tirade
trade65026043tr__ade
triad65217723tri_ad_
triads74513533tri_ads
triage72812893tri_age
triaged92810443triaged
tribades1136893tribades
trigged10359853trigged
triode75311893tri_ode
tzigane1742943tzigane
urinate7315363urinate
virgate1138733virgate
wriggle12316213wriggle

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271536.00322326.7
3Display Results1531530.0602550.0
 (SQL Overall)1786911536.48327563.0
 
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.