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

243 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
brookies145914(None) 
bookies133819401b_ookies
brookie1347371brookie_
brookites1545031brookites
rookies113917101_rookies
bloodies11310162bloodies
boobies113718202b_oobies
boodies103721442b_oodies
boogies103719012b_oogies
bookie123516002b_ookie_
boonies93422482b_oonies
booties94124612b_ooties
brionies10310542brionies
brollies1039532brollies
brooches15288192brooches
broodier1157432broodier
broodiest1237822broodiest
brooked143610032brook_ed
brooking153710702brooking
brookite1445502brookite
brooklet1456402brooklet
brooklets1543682brooklets
brooklimes1841902brooklimes
brooks125813882brook__s
broomier1236872broomier
broomiest1356912broomiest
brownies13189612brownies
bryonies1336842bryonies
cookies133719272_cookies
droskies13186342droskies
hookies144017442_hookies
nookies113414962_nookies
roofies103014412_roofies
rookie103613262_rookie_
rookier114012382_rookier
rookiest122912172_rookiest
roomies93017242_roomies
argosies939523argosies
armories10313653armories
baronies10315023baronies
betonies10413063betonies
bikies124515163b__ikies
biologies12311183biologies
bionomies1397153bionomies
biopsies1237383biopsies
birkies133712433b_irkies
blockier1666133blockier
blockiest1736363blockiest
blokes123813883b_lok_es
bloodied1245973bloodied
bloodier1136823bloodier
bloodiest1236663bloodiest
blooie83913193bloo_ie_
bloomier1275783bloomier
bloomiest1335853bloomiest
bobbies103714563b_obbies
boccies133311513b_occies
bodies94524143b__odies
bodkins1438313b_odkins
bogies94724313b__ogies
boobie104015293b_oobie_
boodles103416043b_oodles
boogie93515993b_oogie_
boogied11379283b_oogied
booked135319503b_ook_ed
booker124719193b_ook_er
bookers134016613b_ookers
booking143618383b_ooking
bookings15358733b_ookings
bookish163610023b_ookish
booklet132312643b_ooklet
booklets14247123b_ooklets
bookmen15126263b_ookmen
bookoos1337503b_ookoos
bookrest1436493b_ookrest
books115729713b_ook__s
boomier113312183b_oomier
boomiest122711843b_oomiest
boomkins1645503boomkins
bootees94114473b_ootees
bootie85421153b_ootie_
boozes174916523b_oo_zes
boozier18349013b_oozier
booziest19379263b_ooziest
boskier13309173b_oskier
boskiest14289733b_oskiest
bossies94116833b_ossies
bothies12414783b_othies
bougies103715183b_ougies
brakes124923123br_ak_es
brakier133812363br_akier
brakiest143912243br_akiest
brandies11714563brandies
brassies103613533brassies
braxies16711463br_axies
brewskies18132273brewskies
brickier16307163brickier
brickiest1737433brickiest
brickles162810283brickles
bries74942153br___ies
brinies93317913br_inies
brioches15227253brioches
broaches153211623broaches
brocades1358713brocades
brockages1844783brockages
brocket154013383brock_et
brockets16328123brockets
brocks145214153brock__s
brocolis1247303brocoli_s
brogues10719823br_ogues
broils84114173br_o_ils
brokages1536253brokages
broke116019783br_ok_e_
broken124011523br_ok_en
broker124314243br_ok_er
brokers133111913br_okers
broking143514823br_oking
brokings15317713br_okings
bromates12413143bromates
bromes104719763br_o_mes
bromides13219363bromides
bromids12278603br_omids
bromines122514253bromines
bromins112513783br_omins
bromizes21258333bromizes
bronzes183510403br_onzes
bronzier1935633bronzier
bronziest2035813bronziest
brooded113510933broo_ded
brooder103811623broo_der
brooders112610243brooders
broodily1445503broodily
broodiness1344653broodiness
brooding122911373brooding
broodless1235033broodless
broods95416383broo__ds
brook114717763brook___
brooklike1453273brooklike
brooklime1752353brooklime
broomed124111053broo_med
brooming132911143brooming
brooms104915873broo__ms
broos75126413broo___s
broses86524403br_o_ses
brownie12178433brownie_
brownier13226913brownier
browniest14207123browniest
browses124712693br_owses
brulyies1343423brulyies
brulzies1933983brulzies
brumbies1436533brumbies
bryologies1646043bryologies
cookie123716043_cookie_
coolies93824963_coolies
cooties93725733_cooties
corodies11313693corodies
croakier14436263croakier
croakiest15167173croakiest
cronies9622503cr_onies
crooked143910943crook_ed
crooker134111093crook_er
crookeries1646133crookeries
crookest1436683crook_est
crooking153611343crooking
crooks124914413crook__s
croppies143111133croppies
crowdies1437543crowdies
dhoolies1246963dhoolies
dhooties1237633dhooties
doobies103915673_doobies
doodies94218773_doodies
doolies83920713_doolies
doozies173812723_doozies
droolier936073droolier
drooliest1036343drooliest
droopier1145573droopier
droopiest1235743droopiest
dropsies1138693dropsies
droshkies1762563droshkies
eurokies1246313eurokies
euryokies1642603euryokies
floosies113210233floosies
floozies20326953floozies
folkies143612253_folkies
foodies113416753_foodies
footies103721543_footies
goodies93516993_goodies
goonies83618333_goonies
grooves11368803groo_ves
groovier1233793groovier
grooviest1334083grooviest
groupies1137523groupies
honkies143015143_honkies
hoodies113419833_hoodies
hookier143811673_hookier
hookiest152712103_hookiest
ironies7517423ir_onies
kookie9389833_kookie_
kookier10398283_kookier
kookiest11268133_kookiest
loobies93814103_loobies
looies65025833_loo_ies
loonies73919543_loonies
noogies82814583_noogies
nookie103712433_nookie_
orologies10311623orologies
pokies125921333__pokies
porkies133416493_porkies
priories10312453priories
prosodies1249733prosodies
prossies101515223prossies
prosties101421193prosties
provokes1776603provok_es
proxies163014933pr_oxies
roadies83317443_roadies
rockier134911883_rockier
rockiest142912223_rockiest
roofie93411173_roofie_
rooked114918143_rook_ed
rookeries13138173_rookeries
rooking123517363_rooking
rooks95325043_rook__s
roomie83013873_roomie_
roomier93812243_roomier
roomiest102611993_roomiest
rooses65526233_roo_ses
rootier74915393_rootier
rootiest83115593_rootiest
rootles73215633_rootles
rowdies113112693_rowdies
spookier14175493spookier
spookiest15156393spookiest
spoonies101911753spoonies
stoolies8311083stoolies
toonies73719883_toonies
trokes104019263tr_ok_es
trollies8310233trollies
trophies13413673trophies
twoonies1155693twoonies
urologies1039533urologies
whoopies16267373whoopies
woodies113517153_woodies
woolies104117363_woolies

Search took 9 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.1731032896.0
2DLD Change Limit1461622438.06018134.2
3Display Results2432430.0962531.3
 (SQL Overall)1786912438.32921454.1
 
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.