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

194 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
brookie134737(None) 
bookie123516001b_ookie
brookies1459141brookies
brookite1445501brookite
rookie103613261_rookie
blooie83913192bloo_ie
boobie104015292b_oobie
boogie93515992b_oogie
bookies133819402b_ookies
bootie85421162b_ootie
broke116019782br_ok_e
broodier1157432broodier
brook114717762brook__
brooked143610032brooked
brooking153710702brooking
brookites1545032brookites
brooklet1456402brooklet
brooklike1453272brooklike
brooklime1752352brooklime
brooks125813882brook_s
broomier1236872broomier
brownie12178432brownie
cookie123716042_cookie
kookie9389842_kookie
nookie103712432_nookie
roofie93411172_roofie
rookier114012382_rookier
rookies113917102_rookies
roomie83013872_roomie
bikie113915883b__ikie
birkie124110133b_irkie
blockier1666133blockier
bloke114316633b_lok_e
bloodied1245973bloodied
bloodier1136823bloodier
bloodies11310163bloodies
bloomier1275783bloomier
boccie123311453b_occie
bodkin1338923b_odkin
bogie89524103b__ogie
bonnie85314853b_onnie
boobies113718203b_oobies
boodies103721443b_oodies
boodle93215033b_oodle
boogied11379283b_oogied
boogies103719013b_oogies
book106836333b_ook__
booked135319503b_ooked
booker124719193b_ooker
booking143618383b_ooking
bookish163610023b_ookish
booklet132312643b_ooklet
booklice1644753b_ooklice
bookmen15126263b_ookmen
bookoo1248343b_ookoo
books115729713b_ook_s
boomier113312183b_oomier
boomkin1545363boomkin
boonies93422483b_oonies
bootee84323023b_ootee
booties94124613b_ooties
booze164718913b_oo_ze
boozier18349013b_oozier
boronic11311163boronic
boskier13309173b_oskier
bougie93613273b_ougie
brake116025343br_ak_e
brakier133812363br_akier
brassie93411523brassie
brawlie12198153brawlie
brickier16307163brickier
brickle15279933brickle
brie65837903br___ie
brioche14275923brioche
brionies10310543brionies
brocade1238533brocade
broche133612103br_oche
brock136017073brock__
brockage1744743brockage
brocket154013383brocket
brocks145214153brock_s
brocoli1146353brocoli_
brocolis1247303brocolis
brogue94211033br_ogue
broil74918223br_o_il
brokage1436673brokage
broken124011523br_oken
broker124314243br_oker
broking143514823br_oking
brollies1039533brollies
bromate11313553bromate
brome94421973br_o_me
bromic122412693br_omic
bromid112612893br_omid
bromide12269583bromide
bromin102615693br_omin
bromine112915243bromine
bromize20238823bromize
bronze173610923br_onze
bronzier1935633bronzier
broo65129823broo___
brooch13368443broo_ch
brooches15288193brooches
brood84620243broo__d
brooded113510933brooded
brooder103811623brooder
broodiest1237823broodiest
broodily1445503broodily
brooding122911373brooding
broods95416383broo_ds
broody124510083broo_dy
brooklets1543683brooklets
brooklimes1841903brooklimes
broom95022213broo__m
broomed124111053broomed
broomiest1356913broomiest
brooming132911143brooming
brooms104915873broo_ms
broomy13449953broo_my
broos75126413broo__s
brose75227033br_o_se
brownier13226913brownier
brownies13189613brownies
browse115713853br_owse
brulyie1242523brulyie
brulzie1842883brulzie
bryonies1336843bryonies
cookies133719273_cookies
coolie83821603_coolie
cootie84223093_cootie
croakier14436263croakier
crook115217573crook__
crooked143910943crooked
crooker134111093crooker
crooking153611343crooking
crooks124914413crook_s
croppie13278793croppie
crowdie1335913crowdie
dhootie1136473dhootie
doobie94712683_doobie
doolie73916833_doolie
doozie163910653_doozie
droolier936073droolier
droopier1145573droopier
droskies13186343droskies
flooie93712153floo_ie
floosie10378933floosie
floozie19295463floozie
folkie13369613_folkie
foodie104413843_foodie
footie94718143_footie
goodie83613993_goodie
goonie73615563_goonie
groove10438873groo_ve
groovier1233793groovier
groupie1045783groupie
honkie133011673_honkie
hoodie105116143_hoodie
hookier143811673_hookier
hookies144017443_hookies
hoolie93217783_hoolie
kookier10398283_kookier
krooni10397183krooni_
looie55624243_loo_ie
loonie64216453_loonie
noogie73612313_noogie
nookies113414963_nookies
oorie53026363__oorie
prossie91812953prossie
prostie91617743prostie
provoke1676123provok_e
roadie72813813_roadie
rockier134911883_rockier
roofies103014413_roofies
rook85532033_rook__
rooked114918143_rooked
rookiest122912173_rookiest
rooking123517363_rooking
rooks95325043_rook_s
rooky126117623_rook_y
roomier93812243_roomier
roomies93017243_roomies
roose56127093_roo_se
rootier74915393_rootier
rootle63214453_rootle
spookier14175493spookier
stoolie739723stoolie
toonie63617993_toonie
trickie132611033trickie
troke94821053tr_ok_e
twoonie1034423twoonie
whoopie15295933whoopie
woodie103513613_woodie
woolie93514483_woolie

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.406440125.6
2DLD Change Limit1340271946.36021073.4
3Display Results1941940.0802425.0
 (SQL Overall)1786911946.84626101.5
 
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.