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

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

209 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
broos7512641(None) 
boos67955031b_oos
brios74725721brios
bromos104213311bromos
broo65129821broo_
brood84620241brood
broods95416381broods
brook114717761brook
brooks125813881brooks
broom95022211broom
brooms104915871brooms
bros65635661br_os
brows105425981brows
arvos86015662arvos
baboos103517012baboos
barons85025382barons
bazoos173212622bazoos
bhoot104322102bhoot
bhoots11459912bhoots
bigos85020012bigos
biogs85016112biogs
bios66335322b_ios
biros75325132biros
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
blood85319522blood
bloods94614842bloods
bloom95918972bloom
blooms104613172blooms
bloop96116152bloop
bloops106611342bloops
blots75626172blots
blows105423832blows
boas66150832b_oas
bobs86340652b_obs
bods76244712b_ods
bogs75742752b_ogs
bohos105618252bohos
bolos75531372bolos
boo58163662b_oo_
boob85932582b_oob
boobs96221992boobs
book106836332b_ook
books115729712books
boom87435672b_oom
booms95427122booms
boon67142172b_oon
boons75031912boons
boor66130682b_oor
boors74325012boors
boost75132472b_oost
boot67759372b_oot
boots75837972boots
bops86037982b_ops
boras75938302boras
bores76448252bores
borks115727702borks
boron76727142boron
borons85520542borons
borts76735452borts
bos57966812b__os
boss65938342b_oss
bots66453952b_ots
bows96242862b_ows
boyos105418282boyos
boys96737332b_oys
bozos165216862bozos
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452br_as
brass75428022brass
brats75336012brats
bravos114711392bravos
braws106425192braws
brays106723112brays
brees75632552brees
brens75823362brens
brews105617072brews
bries74942152bries
brigs85823222brigs
brims94721622brims
brins75533972brins
brio65432492brio_
bris65539612br_is
briss75824272briss
brits76433082brits
bro56236602br_o_
broad84817692broad
broads94515152broads
brock136017072brock
brocks145214152brocks
broil74918222broil
broils84114172broils
broke116019782broke
brome94421972brome
bromes104719762bromes
bromo95217202bromo
bronc91714342bronc
broncos11188072broncos
broncs101611152broncs
brooch13368442brooch
broody124510082broody
broomy13449952broomy
brose75227032brose
broses86524402broses
brosy106115382brosy
broth106521092broth
broths115013922broths
brow97228442br_ow
brown105619532brown
browns116415632browns
browse115713852browse
bruts75922952bruts
buoys104810632buoys
burgoos1037122burgoos
burros85114992burros
coos67456492_coos
crocs95722432crocs
crook115217572crook
crooks124914412crooks
croon75522782croon
croons85418422croons
crops96125242crops
cross75124502cross
crows105727312crows
drool65416102drool
drools74412812drools
droop85814822droop
droops95110962droops
drops85719502drops
dross65418092dross
eros45238452er_os
froes86126692froes
frogs96220772frogs
frons86124042frons
frows116623102frows
goos57644912_goos
grogs76319412grogs
groks105716122groks
groom85317982groom
grooms94512522grooms
gross65421692gross
grots65025852grots
grows95523922grows
irokos1037232irokos
irons55324132irons
karoos102415802karoos
kroon94514482kroon
kroons103711242kroons
loos49051122_loos
moos66051302_moos
ordos65216202ordos
orzos143311252orzos
poos65949112_poos
praos74923562praos
proas75028802proas
prods85523552prods
profs105120892profs
progs86624152progs
promos105116422promos
proms95426412proms
proof105221532proof
proofs114511682proofs
props95726882props
pros65742782pr_os
proso77222412proso
prosos85718552prosos
pross76529402pross
prows106327012prows
rhos76319062_rhos
robs65837872_robs
rocs65533662_rocs
rods56442062_rods
roes45954142_roes
roms67038962_roms
rood56733002_rood
roods65125282_roods
roof75738832_roof
roofs85321152_roofs
rook85532032_rook
rooks95325042_rooks
room66235082_room
rooms75324682_rooms
roose56127092_roose
roost55730932_roost
root45655922_root
roots55933672_roots
rotos56027882_rotos
rots46454092_rots
rows75941752_rows
shoos84226362shoos
toros54336192toros
trios55528092trios
trogs67022602trogs
trois57226092trois
troop76417532troop
troops85712782troops
trooz145016152trooz
trots56629942trots
trows88826182trows
troys86418612troys
vroom105312472vroom
vrooms11398712vrooms
vrows116115262vrows
woos76238802_woos
zoos135828802_zoos

Search took 4 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 Filter178691538000.563317390.8
2DLD Change Limit538002092.78319331.7
3Display Results2092090.436479.4
 (SQL Overall)1786912093.78247247.8
 
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.