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

129 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
brigades123639(None) 
brigade1136491brigade_
brigaded1344571brigaded
brides94423512bri__des
brigadier1343322brigadier
brigadiers1442142brigadiers
brigands1245622brigands
brocades1358702brocades
frigates12310922frigates
tribades1136882tribades
abrades10312073abr__ades
abrogates12108973abrogates
alidades1037003alidades
arcades101113193ar_cades
baggages1335443baggages
ballades114211643ballades
barricades1564203barricades
begazes1937963b_egazes
beiges91014403beig__es
beignes10149243beig_nes
biases84618433b_i_ases
bides85536773b_i__des
bifaces1448063b_ifaces
bigamies1337363b_igamies
bigarades1344133b_igarades
bigeyes1335653b_igeyes
biggies113813523b_iggies
bigoses1039073b_igoses
biogases1136143biogases
blades95221253b__lades
borides10515153bori__des
braces108427773br__aces
brads85528293br__ad_s
braes75735053br__a_es
brakes124923123br__akes
bravadoes1543023bravadoes
bravados1443213bravados
braves115524083br__aves
brazes175522193br__azes
breaded115014063br_eaded
breads95419203br_ead_s
bredes94818473br__edes
brewages1436383brewages
briards10398553bri_ards
briars84814823bri_a_rs
bribees11409283bri_bees
bribes105918533bri__bes
brickles162810283brickles
bricoles122610303bricoles
bridals1038623brida_ls
bride86425533bri__de_
bridges113911333bri_dges
bridles104114473bri_dles
bries74942153bri___es
brigading1445143brigading
brigand1136643briga_nd
brigandages1651263brigandages
brigandines1552433brigandines
brighten1466243brighten
brightens1565373brightens
brighter1476663brighter
brightest1545663brightest
brights133710233brig_hts
brigs85823223brig___s
brinded115112053bri_nded
brindles113710223brindles
brines85028853bri__nes
brinies93317913bri_nies
brioches15227253brioches
brionies10310543brionies
brisances1345843brisances
brises84927613bri__ses
brisses94314313bri_sses
bristles101510433bristles
britches15278683britches
brittles10178653brittles
broaden10289143br_oaden
broadens11267233br_oadens
broader103412603br_oader
broadest1138573br_oadest
broads94515143br_oad_s
brocade1238533brocade_
brocaded1436353brocaded
brogans1049663broga_ns
brogues10719823brog_ues
brokages1536253brokages
bromates12413133bromates
bromides13219363bromides
burgages1236483burgages
crusades1146323crusades
dryades12395633dr_yades
ergates8314473er_gates
frigate11311063frigate_
friges104116483frig__es
grades84926313gr__ades
grenades1038433grenades
grides84422363gri__des
grillades1194543grillades
grimaces1355383grimaces
irades74517393__irades
irides74519123iri__des
irrigates1057253irrigates
ligases82310703_ligases
ligates82318373_ligates
marinades12268973marinades
naiades838213nai_ades
obligates12207853obligates
origamis1145263origamis
origans839973origa_ns
prefades1439533prefades
pregames1339003pregames
prides94324183pri__des
primages13159273primages
primates121515933primates
privates131812373privates
regales83520793_regales
regrades103212163_regrades
rides66140813_ri__des
rivages1138873_rivages
tirades8311723_tirades
trades75724493tr__ades
triads74513523tri_ad_s
triages82613793tri_ages
tribade1037283tribade_
triodes84012503tri_odes
tziganes1853013tziganes
urinates8314133urinates
virgates1237903virgates
wriggles13286263wriggles

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621297.69019006.8
3Display Results1291290.0602150.0
 (SQL Overall)1786911297.90622601.9
 
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.